eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_IMP_PARTIES_INT

Line 156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.

152: AND sdh_batch_id = p_batch_id
153: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
154:
155: -- If the party record is not present insert data into
156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
157: INSERT INTO hz_imp_parties_int
158: (batch_id,
159: party_orig_system,
160: party_orig_system_reference,

Line 157: INSERT INTO hz_imp_parties_int

153: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
154:
155: -- If the party record is not present insert data into
156: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
157: INSERT INTO hz_imp_parties_int
158: (batch_id,
159: party_orig_system,
160: party_orig_system_reference,
161: created_by_module,

Line 187: FROM hz_imp_parties_int hp

183: WHERE /* party_id IS NULL AND */
184: sdh_batch_id = p_batch_id
185: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
186: AND NOT EXISTS (SELECT *
187: FROM hz_imp_parties_int hp
188: WHERE hp.batch_id = supp.sdh_batch_id
189: AND hp.party_orig_system = supp.party_orig_system
190: AND hp.party_orig_system_reference =
191: supp.party_orig_system_reference);

Line 198: ' Rows inserted in hz_imp_parties_int: ' ||

194:
195: fnd_file.put_line(fnd_file.log,
196: ' Message: Inside PROCEDURE check_party_exist' ||
197: ' Parameters: ' || ' p_batch_id: ' || p_batch_id ||
198: ' Rows inserted in hz_imp_parties_int: ' ||
199: l_insert_count);
200:
201: IF (l_insert_count > 0) THEN
202: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

Line 416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.

412: AND sdh_batch_id = p_batch_id
413: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
414:
415: -- If the party record is not present insert data into
416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
417: INSERT INTO hz_imp_parties_int
418: (batch_id,
419: party_orig_system,
420: party_orig_system_reference,

Line 417: INSERT INTO hz_imp_parties_int

413: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
414:
415: -- If the party record is not present insert data into
416: -- HZ_IMP_PARTIES_INT table using AP_SUPPLIERS_INT.
417: INSERT INTO hz_imp_parties_int
418: (batch_id,
419: party_orig_system,
420: party_orig_system_reference,
421: created_by_module,

Line 467: FROM hz_imp_parties_int hp

463: sdh_batch_id = p_batch_id
464: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
465: AND NOT EXISTS
466: (SELECT *
467: FROM hz_imp_parties_int hp
468: WHERE hp.batch_id = supp.sdh_batch_id
469: AND hp.party_orig_system = supp.contact_orig_system
470: AND hp.party_orig_system_reference =
471: supp.contact_orig_system_reference))

Line 479: ' Rows inserted in hz_imp_parties_int: ' ||

475:
476: fnd_file.put_line(fnd_file.log,
477: ' Message: Inside PROCEDURE check_party_contact_exist' ||
478: ' Parameters: ' || ' p_batch_id: ' || p_batch_id ||
479: ' Rows inserted in hz_imp_parties_int: ' ||
480: l_insert_count);
481:
482: IF (l_insert_count > 0) THEN
483: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

Line 645: FROM hz_imp_parties_int hp

641: party_id,
642: party_orig_system,
643: party_orig_system_reference,
644: insert_update_flag
645: FROM hz_imp_parties_int hp
646: WHERE batch_id = p_batch_id
647: /* Status for the data should not be E or C
648: i.e. Errored out or Completed */
649: AND interface_status IS NULL

Line 842: 'HZ_IMP_PARTIES_INT',

838: SYSDATE,
839: hz_imp_errors_s.nextval,
840: p_batch_id,
841: NULL,
842: 'HZ_IMP_PARTIES_INT',
843: 'AR_ALL_DUP_NAME',
844: 'ORGANIZATION_NAME',
845: party_int_rec.organization_name)
846: RETURNING error_id INTO l_error_id;

Line 848: UPDATE hz_imp_parties_int

844: 'ORGANIZATION_NAME',
845: party_int_rec.organization_name)
846: RETURNING error_id INTO l_error_id;
847:
848: UPDATE hz_imp_parties_int
849: SET interface_status = 'E',
850: error_id = l_error_id
851: WHERE ROWID = party_int_rec.rowid;
852:

Line 1262: FROM hz_imp_parties_int hp

1258: party_id,
1259: party_orig_system,
1260: party_orig_system_reference,
1261: insert_update_flag
1262: FROM hz_imp_parties_int hp
1263: WHERE batch_id = p_batch_id
1264: /* Status for the data should not be E or C
1265: i.e. Errored out or Completed */
1266: AND interface_status IS NULL

Line 2062: FROM hz_imp_parties_int party

2058: AND sdh_batch_id = p_batch_id
2059: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
2060: AND NOT EXISTS
2061: (SELECT 1
2062: FROM hz_imp_parties_int party
2063: WHERE batch_id = p_batch_id
2064: AND supp.sdh_batch_id = party.batch_id
2065: AND supp.party_orig_system = party.party_orig_system
2066: AND supp.party_orig_system_reference =

Line 2126: FROM hz_imp_parties_int party

2122: WHERE sdh_batch_id = p_batch_id
2123: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
2124: AND EXISTS
2125: (SELECT 1
2126: FROM hz_imp_parties_int party
2127: WHERE batch_id = p_batch_id
2128: AND supp.sdh_batch_id = party.batch_id
2129: AND supp.party_orig_system = party.party_orig_system
2130: AND supp.party_orig_system_reference =

Line 2137: ' records. Reason interface_status in hz_imp_parties_int = R');

2133:
2134: fnd_file.put_line(fnd_file.log,
2135: ' Message: Inside PROCEDURE IMPORT_VENDORS' ||
2136: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
2137: ' records. Reason interface_status in hz_imp_parties_int = R');
2138:
2139: INSERT INTO pos_supplier_int_rejections
2140: (SELECT p_batch_id,
2141: l_request_id,

Line 2427: FROM hz_imp_parties_int

2423:
2424: BEGIN
2425: SELECT insert_update_flag
2426: INTO l_insert_update_flag
2427: FROM hz_imp_parties_int
2428: WHERE batch_id = p_batch_id
2429: AND party_orig_system = vendor_int_rec.party_orig_system
2430: AND party_orig_system_reference =
2431: vendor_int_rec.party_orig_system_reference;

Line 4790: FROM hz_imp_parties_int party

4786: AND sdh_batch_id = p_batch_id
4787: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
4788: AND NOT EXISTS
4789: (SELECT 1
4790: FROM hz_imp_parties_int party
4791: WHERE batch_id = p_batch_id
4792: AND supp.sdh_batch_id = party.batch_id
4793: AND supp.source_system = party.party_orig_system
4794: AND supp.source_system_reference =

Line 4851: FROM hz_imp_parties_int party

4847: import_request_id = l_request_id
4848: WHERE sdh_batch_id = p_batch_id
4849: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
4850: AND EXISTS (SELECT 1
4851: FROM hz_imp_parties_int party
4852: WHERE batch_id = p_batch_id
4853: AND supp.sdh_batch_id = party.batch_id
4854: AND supp.source_system = party.party_orig_system
4855: AND supp.source_system_reference =

Line 4862: ' records. Reason interface_status in hz_imp_parties_int = R');

4858:
4859: fnd_file.put_line(fnd_file.log,
4860: ' Message: Inside PROCEDURE IMPORT_VENDOR_PRODS_SERVICES' ||
4861: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
4862: ' records. Reason interface_status in hz_imp_parties_int = R');
4863:
4864: INSERT INTO pos_supplier_int_rejections
4865: (SELECT p_batch_id,
4866: l_request_id,

Line 5574: FROM hz_imp_parties_int party

5570: AND sdh_batch_id = p_batch_id
5571: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
5572: AND NOT EXISTS
5573: (SELECT 1
5574: FROM hz_imp_parties_int party
5575: WHERE batch_id = p_batch_id
5576: AND supp.sdh_batch_id = party.batch_id
5577: AND supp.source_system = party.party_orig_system
5578: AND supp.source_system_reference =

Line 5619: FROM hz_imp_parties_int party

5615: import_request_id = l_request_id
5616: WHERE sdh_batch_id = p_batch_id
5617: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
5618: AND EXISTS (SELECT 1
5619: FROM hz_imp_parties_int party
5620: WHERE batch_id = p_batch_id
5621: AND supp.sdh_batch_id = party.batch_id
5622: AND supp.source_system = party.party_orig_system
5623: AND supp.source_system_reference =

Line 5630: ' records. Reason interface_status in hz_imp_parties_int = R');

5626:
5627: fnd_file.put_line(fnd_file.log,
5628: ' Message: Inside PROCEDURE IMPORT_VENDOR_BUSS_CLASS' ||
5629: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
5630: ' records. Reason interface_status in hz_imp_parties_int = R');
5631:
5632: INSERT INTO pos_supplier_int_rejections
5633: (SELECT p_batch_id,
5634: l_request_id,

Line 7343: FROM hz_imp_parties_int party

7339: WHERE batch_id = p_batch_id
7340: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
7341: AND NOT EXISTS
7342: (SELECT 1
7343: FROM hz_imp_parties_int party
7344: WHERE batch_id = p_batch_id
7345: AND supp.batch_id = party.batch_id
7346: AND supp.source_system = party.party_orig_system
7347: AND supp.source_system_reference =

Line 7358: FROM hz_imp_parties_int party

7354: WHERE batch_id = p_batch_id
7355: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
7356: AND NOT EXISTS
7357: (SELECT 1
7358: FROM hz_imp_parties_int party
7359: WHERE batch_id = p_batch_id
7360: AND supp.batch_id = party.batch_id
7361: AND supp.source_system = party.party_orig_system
7362: AND supp.source_system_reference =

Line 7373: FROM hz_imp_parties_int party

7369: WHERE batch_id = p_batch_id
7370: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
7371: AND NOT EXISTS
7372: (SELECT 1
7373: FROM hz_imp_parties_int party
7374: WHERE batch_id = p_batch_id
7375: AND supp.batch_id = party.batch_id
7376: AND supp.source_system = party.party_orig_system
7377: AND supp.source_system_reference =

Line 7462: FROM hz_imp_parties_int party

7458: request_id = l_request_id
7459: WHERE batch_id = p_batch_id
7460: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
7461: AND EXISTS (SELECT 1
7462: FROM hz_imp_parties_int party
7463: WHERE batch_id = p_batch_id
7464: AND supp.batch_id = party.batch_id
7465: AND supp.source_system = party.party_orig_system
7466: AND supp.source_system_reference =

Line 7473: ' records from table pos_party_tax_profile_int. Reason interface_status in hz_imp_parties_int = R');

7469:
7470: fnd_file.put_line(fnd_file.log,
7471: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7472: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7473: ' records from table pos_party_tax_profile_int. Reason interface_status in hz_imp_parties_int = R');
7474:
7475: INSERT INTO pos_supplier_int_rejections
7476: (SELECT p_batch_id,
7477: l_request_id,

Line 7497: FROM hz_imp_parties_int party

7493: request_id = l_request_id
7494: WHERE batch_id = p_batch_id
7495: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
7496: AND EXISTS (SELECT 1
7497: FROM hz_imp_parties_int party
7498: WHERE batch_id = p_batch_id
7499: AND supp.batch_id = party.batch_id
7500: AND supp.source_system = party.party_orig_system
7501: AND supp.source_system_reference =

Line 7508: ' records from table pos_party_tax_reg_int. Reason interface_status in hz_imp_parties_int = R');

7504:
7505: fnd_file.put_line(fnd_file.log,
7506: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7507: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7508: ' records from table pos_party_tax_reg_int. Reason interface_status in hz_imp_parties_int = R');
7509:
7510: INSERT INTO pos_supplier_int_rejections
7511: (SELECT p_batch_id,
7512: l_request_id,

Line 7532: FROM hz_imp_parties_int party

7528: request_id = l_request_id
7529: WHERE batch_id = p_batch_id
7530: AND nvl(status, 'ACTIVE') <> 'PROCESSED'
7531: AND EXISTS (SELECT 1
7532: FROM hz_imp_parties_int party
7533: WHERE batch_id = p_batch_id
7534: AND supp.batch_id = party.batch_id
7535: AND supp.source_system = party.party_orig_system
7536: AND supp.source_system_reference =

Line 7543: ' records from table pos_fiscal_class_int. Reason interface_status in hz_imp_parties_int = R');

7539:
7540: fnd_file.put_line(fnd_file.log,
7541: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7542: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7543: ' records from table pos_fiscal_class_int. Reason interface_status in hz_imp_parties_int = R');
7544:
7545: INSERT INTO pos_supplier_int_rejections
7546: (SELECT p_batch_id,
7547: l_request_id,

Line 8052: FROM hz_imp_parties_int party

8048: AND nvl(interface_status, 'ACTIVE') NOT IN
8049: ('PROCESSED', 'REMOVED')
8050: AND NOT EXISTS
8051: (SELECT 1
8052: FROM hz_imp_parties_int party
8053: WHERE batch_id = p_batch_id
8054: AND supp.batch_id = party.batch_id
8055: AND supp.source_system = party.party_orig_system
8056: AND supp.source_system_reference =

Line 8068: FROM hz_imp_parties_int party

8064: AND nvl(interface_status, 'ACTIVE') NOT IN
8065: ('PROCESSED', 'REMOVED')
8066: AND NOT EXISTS
8067: (SELECT 1
8068: FROM hz_imp_parties_int party
8069: WHERE batch_id = p_batch_id
8070: AND supp.batch_id = party.batch_id
8071: AND supp.source_system = party.party_orig_system
8072: AND supp.source_system_reference =

Line 8191: FROM hz_imp_parties_int party

8187: request_id = l_request_id
8188: WHERE batch_id = p_batch_id
8189: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED'
8190: AND EXISTS (SELECT 1
8191: FROM hz_imp_parties_int party
8192: WHERE batch_id = p_batch_id
8193: AND supp.batch_id = party.batch_id
8194: AND supp.source_system = party.party_orig_system
8195: AND supp.source_system_reference =

Line 8202: ' records from table pos_bank_account_det_int. Reason interface_status in hz_imp_parties_int = R');

8198:
8199: fnd_file.put_line(fnd_file.log,
8200: ' Message: Inside PROCEDURE IMPORT_VENDOR_BANK_DTLS' ||
8201: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
8202: ' records from table pos_bank_account_det_int. Reason interface_status in hz_imp_parties_int = R');
8203:
8204: INSERT INTO pos_supplier_int_rejections
8205: (SELECT p_batch_id,
8206: l_request_id,

Line 8226: FROM hz_imp_parties_int party

8222: request_id = l_request_id
8223: WHERE batch_id = p_batch_id
8224: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED'
8225: AND EXISTS (SELECT 1
8226: FROM hz_imp_parties_int party
8227: WHERE batch_id = p_batch_id
8228: AND supp.batch_id = party.batch_id
8229: AND supp.source_system = party.party_orig_system
8230: AND supp.source_system_reference =

Line 8237: ' records from table pos_bank_accnt_owners_int. Reason interface_status in hz_imp_parties_int = R');

8233:
8234: fnd_file.put_line(fnd_file.log,
8235: ' Message: Inside PROCEDURE IMPORT_VENDOR_BANK_DTLS' ||
8236: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
8237: ' records from table pos_bank_accnt_owners_int. Reason interface_status in hz_imp_parties_int = R');
8238:
8239: INSERT INTO pos_supplier_int_rejections
8240: (SELECT p_batch_id,
8241: l_request_id,