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 767: FROM po_session_gt psg

763: , financials_system_params_all fsp
764: , per_all_people_f ppf
765: , ( SELECT psg.index_num1 line_location_id
766: , psg.num1 deliver_to_person_id
767: FROM po_session_gt psg
768: WHERE psg.key = p_gt_key ) psg
769: WHERE poha.po_header_id = p_doc_id
770: AND poha.revision_num = p_doc_revision
771: AND pola.po_header_id = poha.po_header_id

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

927: -- distributions, if one exists), we do a two-step pre-processing
928: -- on the PO's shipments and distributions:
929: -- 1. For the latest revision of each distribution with a
930: -- non-null deliver to person on
931: -- the PO, create a record in PO_SESSION_GT containing the
932: --- line_location_id, distribution_num, and deliver_to_person_id.
933: -- 2. From the data inserted in step 1, select the deliver_to_person_id
934: -- from the first distribution on each shipment, inserting the
935: -- results into PO_SESSION_GT.

Line 935: -- results into PO_SESSION_GT.

931: -- the PO, create a record in PO_SESSION_GT containing the
932: --- line_location_id, distribution_num, and deliver_to_person_id.
933: -- 2. From the data inserted in step 1, select the deliver_to_person_id
934: -- from the first distribution on each shipment, inserting the
935: -- results into PO_SESSION_GT.
936: --
937: -- Our main cursor query will then join with the entries created in step 2
938: -- to get the appropriate requester for each shipment.
939:

Line 945: INSERT INTO po_session_gt

941: l_gt_key1 := PO_CORE_S.get_session_gt_nextval();
942:
943: d_progress := '015';
944:
945: INSERT INTO po_session_gt
946: ( key
947: , index_num1 -- line_location_id
948: , index_num2 -- distribution_num
949: , num1 -- deliver_to_person_id

Line 984: INSERT INTO po_session_gt

980: l_gt_key2 := PO_CORE_S.get_session_gt_nextval();
981:
982: d_progress := '025';
983:
984: INSERT INTO po_session_gt
985: ( key
986: , index_num1 -- line_location_id
987: , num1 -- deliver_to_person_id
988: )

Line 992: FROM po_session_gt psg

988: )
989: ( SELECT l_gt_key2
990: , psg.index_num1
991: , psg.num1
992: FROM po_session_gt psg
993: , ( SELECT MIN(psg2.index_num2) distribution_num
994: , psg2.index_num1 line_location_id
995: FROM po_session_gt psg2
996: WHERE psg2.key = l_gt_key1

Line 995: FROM po_session_gt psg2

991: , psg.num1
992: FROM po_session_gt psg
993: , ( SELECT MIN(psg2.index_num2) distribution_num
994: , psg2.index_num1 line_location_id
995: FROM po_session_gt psg2
996: WHERE psg2.key = l_gt_key1
997: GROUP BY psg2.index_num1 ) min_dists
998: WHERE psg.key = l_gt_key1
999: AND psg.index_num1 = min_dists.line_location_id

Line 1521: FROM po_session_gt psg

1517: , financials_system_params_all fsp
1518: , per_all_people_f ppf
1519: , ( SELECT psg.index_num1 line_location_id
1520: , psg.num1 deliver_to_person_id
1521: FROM po_session_gt psg
1522: WHERE psg.key = p_gt_key ) psg
1523: WHERE pora.po_release_id = p_doc_id
1524: AND pora.revision_num = p_doc_revision
1525: AND poha.po_header_id = pora.po_header_id

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

1692: -- distributions, if one exists), we do a two-step pre-processing
1693: -- on the PO's shipments and distributions:
1694: -- 1. For the latest revision of each distribution with a
1695: -- non-null deliver to person on
1696: -- the PO, create a record in PO_SESSION_GT containing the
1697: --- line_location_id, distribution_num, and deliver_to_person_id.
1698: -- 2. From the data inserted in step 1, select the deliver_to_person_id
1699: -- from the first distribution on each shipment, inserting the
1700: -- results into PO_SESSION_GT.

Line 1700: -- results into PO_SESSION_GT.

1696: -- the PO, create a record in PO_SESSION_GT containing the
1697: --- line_location_id, distribution_num, and deliver_to_person_id.
1698: -- 2. From the data inserted in step 1, select the deliver_to_person_id
1699: -- from the first distribution on each shipment, inserting the
1700: -- results into PO_SESSION_GT.
1701: --
1702: -- Our main cursor query will then join with the entries created in step 2
1703: -- to get the appropriate requester for each shipment.
1704:

Line 1710: INSERT INTO po_session_gt

1706: l_gt_key1 := PO_CORE_S.get_session_gt_nextval();
1707:
1708: d_progress := '015';
1709:
1710: INSERT INTO po_session_gt
1711: ( key
1712: , index_num1 -- line_location_id
1713: , index_num2 -- distribution_num
1714: , num1 -- deliver_to_person_id

Line 1749: INSERT INTO po_session_gt

1745: l_gt_key2 := PO_CORE_S.get_session_gt_nextval();
1746:
1747: d_progress := '025';
1748:
1749: INSERT INTO po_session_gt
1750: ( key
1751: , index_num1 -- line_location_id
1752: , num1 -- deliver_to_person_id
1753: )

Line 1757: FROM po_session_gt psg

1753: )
1754: ( SELECT l_gt_key2
1755: , psg.index_num1
1756: , psg.num1
1757: FROM po_session_gt psg
1758: , ( SELECT MIN(psg2.index_num2) distribution_num
1759: , psg2.index_num1 line_location_id
1760: FROM po_session_gt psg2
1761: WHERE psg2.key = l_gt_key1

Line 1760: FROM po_session_gt psg2

1756: , psg.num1
1757: FROM po_session_gt psg
1758: , ( SELECT MIN(psg2.index_num2) distribution_num
1759: , psg2.index_num1 line_location_id
1760: FROM po_session_gt psg2
1761: WHERE psg2.key = l_gt_key1
1762: GROUP BY psg2.index_num1 ) min_dists
1763: WHERE psg.key = l_gt_key1
1764: AND psg.index_num1 = min_dists.line_location_id