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_SPM_WF_PKG1 dependencies on POS_SUPPLIER_REGISTRATIONS

Line 1399: FROM pos_supplier_registrations

1395: x_ou_id OUT nocopy NUMBER)
1396: IS
1397: CURSOR l_cur IS
1398: SELECT ou_id
1399: FROM pos_supplier_registrations
1400: WHERE supplier_reg_id = p_supplier_reg_id;
1401: BEGIN
1402: OPEN l_cur;
1403: FETCH l_cur INTO x_ou_id;

Line 1417: FROM pos_supplier_registrations

1413: x_name OUT nocopy VARCHAR2)
1414: IS
1415: CURSOR l_cur IS
1416: SELECT supplier_name
1417: FROM pos_supplier_registrations
1418: WHERE supplier_reg_id = p_supplier_reg_id;
1419: BEGIN
1420: OPEN l_cur;
1421: FETCH l_cur INTO x_name;

Line 1841: FROM pos_supplier_registrations

1837: l_supplier_reg_id NUMBER;
1838:
1839: CURSOR l_cur IS
1840: SELECT note_to_supplier
1841: FROM pos_supplier_registrations
1842: WHERE supplier_reg_id = l_supplier_reg_id;
1843:
1844: l_rec l_cur%ROWTYPE;
1845: l_enterprise_name hz_parties.party_name%TYPE;

Line 1849: -- the document id should be the supplier_reg_id for the registration in pos_supplier_registrations

1845: l_enterprise_name hz_parties.party_name%TYPE;
1846: l_step NUMBER;
1847: BEGIN
1848: l_step := 0;
1849: -- the document id should be the supplier_reg_id for the registration in pos_supplier_registrations
1850: l_supplier_reg_id := To_number(document_id);
1851:
1852: l_step := 1;
1853: OPEN l_cur;

Line 2887: FROM pos_supplier_registrations psr,

2883: l_process wf_process_activities.process_name%TYPE;
2884:
2885: CURSOR l_cur IS
2886: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address
2887: FROM pos_supplier_registrations psr,
2888: pos_contact_requests pcr,
2889: pos_supplier_mappings psm
2890: WHERE psr.supplier_reg_id = psm.supplier_reg_id
2891: AND psr.supplier_reg_id = p_supplier_reg_id

Line 2960: FROM pos_supplier_registrations psr,

2956: l_process wf_process_activities.process_name%TYPE;
2957:
2958: CURSOR l_cur IS
2959: SELECT psr.reg_key, pcr.first_name, pcr.last_name, pcr.email_address
2960: FROM pos_supplier_registrations psr,
2961: pos_contact_requests pcr,
2962: pos_supplier_mappings psm
2963: WHERE psr.supplier_reg_id = psm.supplier_reg_id
2964: AND psr.supplier_reg_id = p_supplier_reg_id