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.PO_OTM_INTEGRATION_PVT dependencies on PO_SESSION_GT

Line 837: FROM po_session_gt psg

833: , financials_system_params_all fsp
834: , per_all_people_f ppf
835: , ( SELECT psg.index_num1 line_location_id
836: , psg.num1 deliver_to_person_id
837: FROM po_session_gt psg
838: WHERE psg.key = p_gt_key ) psg
839: WHERE poha.po_header_id = p_doc_id
840: AND poha.revision_num = p_doc_revision
841: AND pola.po_header_id = poha.po_header_id

Line 1001: -- the PO, create a record in PO_SESSION_GT containing the

997: -- distributions, if one exists), we do a two-step pre-processing
998: -- on the PO's shipments and distributions:
999: -- 1. For the latest revision of each distribution with a
1000: -- non-null deliver to person on
1001: -- the PO, create a record in PO_SESSION_GT containing the
1002: --- line_location_id, distribution_num, and deliver_to_person_id.
1003: -- 2. From the data inserted in step 1, select the deliver_to_person_id
1004: -- from the first distribution on each shipment, inserting the
1005: -- results into PO_SESSION_GT.

Line 1005: -- results into PO_SESSION_GT.

1001: -- the PO, create a record in PO_SESSION_GT containing the
1002: --- line_location_id, distribution_num, and deliver_to_person_id.
1003: -- 2. From the data inserted in step 1, select the deliver_to_person_id
1004: -- from the first distribution on each shipment, inserting the
1005: -- results into PO_SESSION_GT.
1006: --
1007: -- Our main cursor query will then join with the entries created in step 2
1008: -- to get the appropriate requester for each shipment.
1009:

Line 1015: INSERT INTO po_session_gt

1011: l_gt_key1 := PO_CORE_S.get_session_gt_nextval();
1012:
1013: d_progress := '015';
1014:
1015: INSERT INTO po_session_gt
1016: ( key
1017: , index_num1 -- line_location_id
1018: , index_num2 -- distribution_num
1019: , num1 -- deliver_to_person_id

Line 1054: INSERT INTO po_session_gt

1050: l_gt_key2 := PO_CORE_S.get_session_gt_nextval();
1051:
1052: d_progress := '025';
1053:
1054: INSERT INTO po_session_gt
1055: ( key
1056: , index_num1 -- line_location_id
1057: , num1 -- deliver_to_person_id
1058: )

Line 1062: FROM po_session_gt psg

1058: )
1059: ( SELECT l_gt_key2
1060: , psg.index_num1
1061: , psg.num1
1062: FROM po_session_gt psg
1063: , ( SELECT MIN(psg2.index_num2) distribution_num
1064: , psg2.index_num1 line_location_id
1065: FROM po_session_gt psg2
1066: WHERE psg2.key = l_gt_key1

Line 1065: FROM po_session_gt psg2

1061: , psg.num1
1062: FROM po_session_gt psg
1063: , ( SELECT MIN(psg2.index_num2) distribution_num
1064: , psg2.index_num1 line_location_id
1065: FROM po_session_gt psg2
1066: WHERE psg2.key = l_gt_key1
1067: GROUP BY psg2.index_num1 ) min_dists
1068: WHERE psg.key = l_gt_key1
1069: AND psg.index_num1 = min_dists.line_location_id

Line 1593: FROM po_session_gt psg

1589: , financials_system_params_all fsp
1590: , per_all_people_f ppf
1591: , ( SELECT psg.index_num1 line_location_id
1592: , psg.num1 deliver_to_person_id
1593: FROM po_session_gt psg
1594: WHERE psg.key = p_gt_key ) psg
1595: WHERE pora.po_release_id = p_doc_id
1596: AND pora.revision_num = p_doc_revision
1597: AND poha.po_header_id = pora.po_header_id

Line 1768: -- the PO, create a record in PO_SESSION_GT containing the

1764: -- distributions, if one exists), we do a two-step pre-processing
1765: -- on the PO's shipments and distributions:
1766: -- 1. For the latest revision of each distribution with a
1767: -- non-null deliver to person on
1768: -- the PO, create a record in PO_SESSION_GT containing the
1769: --- line_location_id, distribution_num, and deliver_to_person_id.
1770: -- 2. From the data inserted in step 1, select the deliver_to_person_id
1771: -- from the first distribution on each shipment, inserting the
1772: -- results into PO_SESSION_GT.

Line 1772: -- results into PO_SESSION_GT.

1768: -- the PO, create a record in PO_SESSION_GT containing the
1769: --- line_location_id, distribution_num, and deliver_to_person_id.
1770: -- 2. From the data inserted in step 1, select the deliver_to_person_id
1771: -- from the first distribution on each shipment, inserting the
1772: -- results into PO_SESSION_GT.
1773: --
1774: -- Our main cursor query will then join with the entries created in step 2
1775: -- to get the appropriate requester for each shipment.
1776:

Line 1782: INSERT INTO po_session_gt

1778: l_gt_key1 := PO_CORE_S.get_session_gt_nextval();
1779:
1780: d_progress := '015';
1781:
1782: INSERT INTO po_session_gt
1783: ( key
1784: , index_num1 -- line_location_id
1785: , index_num2 -- distribution_num
1786: , num1 -- deliver_to_person_id

Line 1821: INSERT INTO po_session_gt

1817: l_gt_key2 := PO_CORE_S.get_session_gt_nextval();
1818:
1819: d_progress := '025';
1820:
1821: INSERT INTO po_session_gt
1822: ( key
1823: , index_num1 -- line_location_id
1824: , num1 -- deliver_to_person_id
1825: )

Line 1829: FROM po_session_gt psg

1825: )
1826: ( SELECT l_gt_key2
1827: , psg.index_num1
1828: , psg.num1
1829: FROM po_session_gt psg
1830: , ( SELECT MIN(psg2.index_num2) distribution_num
1831: , psg2.index_num1 line_location_id
1832: FROM po_session_gt psg2
1833: WHERE psg2.key = l_gt_key1

Line 1832: FROM po_session_gt psg2

1828: , psg.num1
1829: FROM po_session_gt psg
1830: , ( SELECT MIN(psg2.index_num2) distribution_num
1831: , psg2.index_num1 line_location_id
1832: FROM po_session_gt psg2
1833: WHERE psg2.key = l_gt_key1
1834: GROUP BY psg2.index_num1 ) min_dists
1835: WHERE psg.key = l_gt_key1
1836: AND psg.index_num1 = min_dists.line_location_id