APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on AP_SUPPLIERS

Line 297: from ap_suppliers

293: end if;
294: elsif l_THIRD_PARTY_TYPE = 'S' and l_THIRD_PARTY_NUMBER is not null then
295: select count(*)
296: into l_count
297: from ap_suppliers
298: where Segment1 =l_THIRD_PARTY_NUMBER;
299: if l_count=0 then
300: update ja_cn_item_interface
301: set status='ETP4'

Line 2411: from ap_suppliers

2407: where Party_Number =l_THIRD_PARTY_NUMBER;
2408: elsif l_third_party_type='S' then
2409: select vendor_id
2410: into l_third_party_id
2411: from ap_suppliers
2412: where Segment1 =l_THIRD_PARTY_NUMBER;
2413: end if;
2414: update ja_cn_journal_lines
2415: set third_party_id=l_third_party_id