DBA Data[Home] [Help]

APPS.IBE_BI_STR_MIG_PVT dependencies on IBE_MSITE_CURRENCIES

Line 739: FROM ibe_msite_currencies

735: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
736: 'GUEST', walkin_prc_listid) price_list_id,
737: msite_id,
738: currency_code
739: FROM ibe_msite_currencies
740: WHERE decode (p_party_type, 'PERSON',registered_prc_listid,
741: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
742: 'GUEST', walkin_prc_listid)
743: IN

Line 747: FROM ibe_msite_currencies

743: IN
744: (SELECT decode (p_party_type, 'PERSON',registered_prc_listid,
745: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
746: 'GUEST', walkin_prc_listid) price_list_id
747: FROM ibe_msite_currencies
748: GROUP BY decode (p_party_type, 'PERSON',registered_prc_listid,
749: 'PARTY_RELATIONSHIP', bizpartner_prc_listid,
750: 'GUEST', walkin_prc_listid)
751: HAVING count(*) = 1 );