APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on AP_SUPPLIERS

Line 67: FROM ap_suppliers

63: SELECT party_id
64: BULK COLLECT
65: INTO partyid_list
66: FROM (SELECT party_id
67: FROM ap_suppliers
68: WHERE last_update_date BETWEEN l_from_date AND l_to_date
69: UNION
70: SELECT ap.party_id
71: FROM hz_parties hz,

Line 72: ap_suppliers ap

68: WHERE last_update_date BETWEEN l_from_date AND l_to_date
69: UNION
70: SELECT ap.party_id
71: FROM hz_parties hz,
72: ap_suppliers ap
73: WHERE hz.party_id = ap.party_id
74: AND hz.last_update_date BETWEEN l_from_date AND l_to_date
75: UNION
76: SELECT ap.party_id

Line 78: ap_suppliers ap

74: AND hz.last_update_date BETWEEN l_from_date AND l_to_date
75: UNION
76: SELECT ap.party_id
77: FROM ap_supplier_sites_all aps,
78: ap_suppliers ap
79: WHERE aps.vendor_id = ap.vendor_id
80: AND aps.last_update_date BETWEEN l_from_date AND l_to_date
81: UNION
82: SELECT ap.party_id

Line 84: ap_suppliers ap,

80: AND aps.last_update_date BETWEEN l_from_date AND l_to_date
81: UNION
82: SELECT ap.party_id
83: FROM hz_locations hz,
84: ap_suppliers ap,
85: ap_supplier_sites_all ss
86: WHERE ss.vendor_id = ap.vendor_id
87: AND hz.location_id = ss.location_id
88: AND hz.last_update_date BETWEEN l_from_date AND l_to_date

Line 92: ap_suppliers ap

88: AND hz.last_update_date BETWEEN l_from_date AND l_to_date
89: UNION
90: SELECT ap.party_id
91: FROM pos_bus_class_attr pbca,
92: ap_suppliers ap
93: WHERE pbca.vendor_id = ap.vendor_id
94: AND pbca.last_update_date BETWEEN l_from_date AND l_to_date
95: UNION
96: SELECT ap.party_id

Line 99: ap_suppliers ap

95: UNION
96: SELECT ap.party_id
97: FROM iby_pmt_instr_uses_all instr,
98: iby_external_payees_all payee,
99: ap_suppliers ap
100: WHERE instr.ext_pmt_party_id = payee.ext_payee_id
101: AND payee.payee_party_id = ap.party_id
102: AND instr.last_update_date BETWEEN l_from_date AND l_to_date
103: UNION

Line 106: ap_suppliers ap

102: AND instr.last_update_date BETWEEN l_from_date AND l_to_date
103: UNION
104: SELECT ap.party_id
105: FROM iby_external_payees_all payee,
106: ap_suppliers ap
107: WHERE payee.payee_party_id = ap.party_id
108: AND payee.last_update_date BETWEEN l_from_date AND l_to_date
109: UNION
110: SELECT ap.party_id

Line 112: ap_suppliers ap

108: AND payee.last_update_date BETWEEN l_from_date AND l_to_date
109: UNION
110: SELECT ap.party_id
111: FROM zx_party_tax_profile tax,
112: ap_suppliers ap
113: WHERE tax.party_id = ap.party_id
114: AND tax.last_update_date BETWEEN l_from_date AND l_to_date
115: UNION
116: SELECT ap.party_id

Line 118: ap_suppliers ap,

114: AND tax.last_update_date BETWEEN l_from_date AND l_to_date
115: UNION
116: SELECT ap.party_id
117: FROM ap_supplier_contacts apsc,
118: ap_suppliers ap,
119: ap_supplier_sites_all sa
120: WHERE sa.vendor_id = ap.vendor_id
121: AND apsc.vendor_site_id = sa.vendor_site_id
122: AND apsc.last_update_date BETWEEN l_from_date AND l_to_date

Line 126: ap_suppliers ap

122: AND apsc.last_update_date BETWEEN l_from_date AND l_to_date
123: UNION
124: SELECT ap.party_id
125: FROM pos_sup_products_services ps,
126: ap_suppliers ap
127: WHERE ps.vendor_id = ap.vendor_id
128: AND ps.last_update_date BETWEEN l_from_date AND l_to_date
129:
130: UNION

Line 138: ap_suppliers ap,

134: hz_parties bp,
135: hz_party_sites s,
136: iby_account_owners ow,
137: hz_parties br,
138: ap_suppliers ap,
139: iby_ext_bank_accounts eb,
140: hz_code_assignments branchca,
141: hz_contact_points branchcp
142: WHERE eb.bank_id = bp.party_id(+)

Line 164: FROM ap_suppliers ap,

160: AND eb.last_update_date BETWEEN l_from_date AND l_to_date
161:
162: UNION
163: SELECT ap.party_id
164: FROM ap_suppliers ap,
165: pos_supp_prof_ext_b ext
166: WHERE ap.party_id = ext.party_id
167: AND ext.last_update_date BETWEEN l_from_date AND l_to_date);
168: