DBA Data[Home] [Help]

APPS.EC_INBOUND_STAGE dependencies on ECE_TP_DETAILS

Line 1157: from ece_tp_details td,

1153: i_transaction_type IN varchar2
1154: )
1155: IS
1156: select tp_code
1157: from ece_tp_details td,
1158: hz_cust_acct_sites_all hcas,
1159: ece_tp_headers th
1160: where td.translator_code = i_translator_code and
1161: hcas.ece_tp_location_code = i_location_code and

Line 1180: from ece_tp_details td,

1176: i_transaction_type IN varchar2
1177: )
1178: IS
1179: select tp_code
1180: from ece_tp_details td,
1181: ra_addresses ra,
1182: ece_tp_headers th
1183: where td.translator_code = i_translator_code and
1184: ra.ece_tp_location_code = i_location_code and

Line 1199: from ece_tp_details td,

1195: i_transaction_type IN varchar2
1196: )
1197: IS
1198: select tp_code
1199: from ece_tp_details td,
1200: po_vendor_sites pvs,
1201: ece_tp_headers th
1202: where td.translator_code = i_translator_code and
1203: pvs.ece_tp_location_code = i_location_code and

Line 1217: from ece_tp_details td,

1213: i_transaction_type IN varchar2
1214: )
1215: IS
1216: select tp_code
1217: from ece_tp_details td,
1218: ap_bank_branches abb,
1219: ece_tp_headers th
1220: where td.translator_code = i_translator_code and
1221: abb.ece_tp_location_code = i_location_code and

Line 1236: from ece_tp_details td,

1232: i_transaction_type IN varchar2
1233: )
1234: IS
1235: select tp_code
1236: from ece_tp_details td,
1237: hr_locations hrl,
1238: ece_tp_headers th
1239: where td.translator_code = i_translator_code and
1240: hrl.ece_tp_location_code = i_location_code and