Skip to main content

Useful Queries


Link Between IBY_CREDITCARD and AP_CARDS_ALL

     select * from apps.iby_creditcard ibc, apps.ap_cards_all aca where  ibc.instrid = aca.card_id 

Comments

  1. ZyApril 20, 2016 at 9:16 PM

    I get more records using

    select * from apps.iby_creditcard ibc, apps.ap_cards_all aca where ibc.instrid = aca.card_reference_id;

    ReplyDelete
  2. Sreekanth Reddy PothulaApril 21, 2016 at 9:26 AM

    yes, this will give all credit cards information. Can you please explain about the exact issue you are facing? Do you mean, you are getting duplicate records? If so, check the org_id.

    Thanks,
    Sree

    ReplyDelete
  3. ZyJune 30, 2016 at 5:08 PM

    The exact issue I am facing is that the ap_cards_all.card_id doesn't match the ap_cards_all.card_reference_id, and if I match the iby_creditcard table using the card_id I get 632 records, but if I match by card_reference_id I get 771 records. I have 772 records in ap_cards_all by 1081 records in the iby_creditcard table.

    ReplyDelete

Post a Comment