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_UDA_AUTOCREATE_PKG dependencies on PO_LINES_INTERFACE

Line 811: FROM po_lines_interface

807: l_progress := '040';
808:
809: SELECT bid_number
810: INTO x_pk1_value
811: FROM po_lines_interface
812: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
813: AND ROWNUM=1;
814:
815: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL

Line 821: FROM po_lines_interface

817:
818: l_progress := '050';
819:
820: SELECT bid_line_number INTO x_pk2_value
821: FROM po_lines_interface
822: WHERE interface_header_id = po_autocreate_params.g_interface_header_id
823: AND interface_line_id = p_intf_line_id;
824: END IF;
825:

Line 835: FROM po_lines_interface

831: INTO x_pk1_value
832: FROM pon_bid_headers
833: WHERE BID_NUMBER=
834: (SELECT bid_number
835: FROM po_lines_interface
836: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
837: AND ROWNUM=1);
838:
839: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL

Line 845: FROM po_lines_interface PLI, pon_bid_item_prices bid

841:
842: l_progress := '070';
843:
844: SELECT bid.auction_line_number INTO x_pk2_value
845: FROM po_lines_interface PLI, pon_bid_item_prices bid
846: WHERE 1=1
847: AND PLI.interface_line_id = p_intf_line_id
848: AND bid.bid_number = PLI.bid_number
849: AND bid.line_number = PLI.bid_line_number;

Line 860: FROM po_lines_interface

856: INTO x_pk1_value
857: FROM po_requisition_lines_all
858: WHERE requisition_line_id =(
859: SELECT requisition_line_id
860: FROM po_lines_interface
861: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
862: AND requisition_line_id IS NOT NULL
863: AND ROWNUM=1);
864:

Line 871: FROM PO_LINES_INTERFACE

867: l_progress := '090';
868:
869: SELECT requisition_line_id
870: INTO x_pk1_value
871: FROM PO_LINES_INTERFACE
872: WHERE interface_line_id= p_intf_line_id;
873: END IF;
874:
875: ELSIF p_doc_type = 'IDV' THEN

Line 879: -- We can get it from po_lines_interface.from_header_id

875: ELSIF p_doc_type = 'IDV' THEN
876:
877: l_progress := '100';
878:
879: -- We can get it from po_lines_interface.from_header_id
880: SELECT IDV_HEADER_ID , -1
881: INTO x_pk1_value , x_pk2_value
882: FROM pon_bid_headers
883: WHERE BID_NUMBER=

Line 885: FROM po_lines_interface

881: INTO x_pk1_value , x_pk2_value
882: FROM pon_bid_headers
883: WHERE BID_NUMBER=
884: (SELECT bid_number
885: FROM po_lines_interface
886: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
887: AND ROWNUM=1);
888:
889: IF x_pk1_value IS NOT NULL THEN

Line 901: -- We can get it from po_lines_interface.from_line_id

897: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL
898: THEN
899:
900: l_progress := '110';
901: -- We can get it from po_lines_interface.from_line_id
902: SELECT bid.idv_line_id, -1 INTO x_pk1_value, x_pk2_value
903: FROM po_lines_interface PLI, pon_bid_item_prices bid
904: WHERE 1=1
905: AND PLI.interface_line_id = p_intf_line_id

Line 903: FROM po_lines_interface PLI, pon_bid_item_prices bid

899:
900: l_progress := '110';
901: -- We can get it from po_lines_interface.from_line_id
902: SELECT bid.idv_line_id, -1 INTO x_pk1_value, x_pk2_value
903: FROM po_lines_interface PLI, pon_bid_item_prices bid
904: WHERE 1=1
905: AND PLI.interface_line_id = p_intf_line_id
906: AND bid.bid_number = PLI.bid_number
907: AND bid.line_number = PLI.bid_line_number;

Line 926: FROM PO_LINES_INTERFACE

922: SELECT requisition_header_id
923: INTO x_pk1_value
924: FROM po_requisition_lines_all
925: WHERE requisition_line_id =( SELECT requisition_line_id
926: FROM PO_LINES_INTERFACE
927: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
928: AND ROWNUM=1);
929: END IF;
930:

Line 935: FROM PO_LINES_INTERFACE

931: IF p_doc_level='LINE' AND p_intf_line_id IS NOT NULL
932: THEN
933: l_progress := '140';
934: SELECT requisition_line_id INTO x_pk1_value
935: FROM PO_LINES_INTERFACE
936: WHERE interface_line_id= p_intf_line_id;
937: END IF;
938:
939: -- If the requisition referencing a Agreement (IDV)

Line 946: FROM po_lines_interface

942: l_progress := '150';
943:
944: -- : from_header_id in case of Blanket & contract_id in case of Contract
945: SELECT Nvl(from_header_id,contract_id), -1 INTO x_pk1_value, x_pk2_value
946: FROM po_lines_interface
947: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
948: AND (from_header_id is not NULL OR contract_id IS NOT NULL)
949: AND ROWNUM=1;
950:

Line 963: FROM po_lines_interface

959: THEN
960: l_progress := '170';
961:
962: SELECT from_line_id,-1 INTO x_pk1_value, x_pk2_value
963: FROM po_lines_interface
964: WHERE interface_line_id= p_intf_line_id;
965: END IF;
966:
967: /* Commenting the following code as these cases doesn't arise.

Line 975: FROM po_lines_interface

971:
972: l_progress := '180';
973:
974: SELECT from_header_id INTO x_pk1_value
975: FROM po_lines_interface
976: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
977: AND from_header_id is not null
978: AND ROWNUM=1;
979:

Line 992: FROM po_lines_interface

988: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL
989: THEN
990: l_progress := '200';
991: SELECT from_line_id INTO x_pk2_value
992: FROM po_lines_interface
993: WHERE interface_line_id= p_intf_line_id;
994:
995: l_progress := '210';
996: SELECT line_number

Line 1009: FROM po_lines_interface

1005:
1006: l_progress := '220';
1007:
1008: SELECT from_header_id INTO x_pk1_value
1009: FROM po_lines_interface
1010: WHERE interface_header_id=po_autocreate_params.g_interface_header_id
1011: AND ROWNUM=1;
1012:
1013: l_progress := '230';

Line 1024: FROM po_lines_interface

1020: IF x_pk1_value IS NOT NULL AND p_doc_level='LINE' AND p_intf_line_id IS NOT NULL
1021: THEN
1022: l_progress := '240';
1023: SELECT from_line_id INTO x_pk2_value
1024: FROM po_lines_interface
1025: WHERE interface_line_id= p_intf_line_id;
1026:
1027: l_progress := '250';
1028: SELECT auction_line_number

Line 1602: FROM po_lines_interface pli

1598: Rank() over(partition BY PLI.line_num order by PLI.line_num,
1599: pli.shipment_num,
1600: pli.unit_price,
1601: PLI.interface_line_id) rn
1602: FROM po_lines_interface pli
1603: WHERE pli.interface_header_id = po_autocreate_params.g_interface_header_id
1604: /*Bug : 13561015
1605: Introducing an NVL condition which take NULL value(coming from SOURCING) in action
1606: as NEW action.

Line 1674: FROM po_lines_interface PLI

1670: ORDER BY pli.line_num,
1671: pli.shipment_num,
1672: pli.unit_price,
1673: pli.interface_line_id) rn
1674: FROM po_lines_interface PLI
1675: WHERE pli.interface_header_id = po_autocreate_params.g_interface_header_id
1676: /*Bug : 13561015
1677: Introducing an NVL condition which take NULL value(coming from SOURCING) in action
1678: as NEW action.

Line 1800: FROM po_line_types plt, po_lines_interface pli

1796: for ORDER_TYPE_LOOKUP_CODE = amount , added condition for Fixed price.*/
1797: CURSOR cur_src_lines
1798: IS
1799: SELECT PLI.interface_line_id,PLI.requisition_line_id,PLI.bid_number,PLI.bid_line_number,PLI.line_num
1800: FROM po_line_types plt, po_lines_interface pli
1801: WHERE plt.line_type_id = pli.line_type_id
1802: AND plt.ORDER_TYPE_LOOKUP_CODE IN ('AMOUNT','FIXED PRICE')--Bug 9945827
1803: AND PLI.interface_header_id = po_autocreate_params.g_interface_header_id
1804: --CLM Phase 2 Autocreate Changes start

Line 1812: FROM po_lines_interface

1808: as NEW action.
1809: */
1810: and Nvl(pli.action,'NEW') = 'NEW'
1811: AND line_num = (SELECT line_num
1812: FROM po_lines_interface
1813: WHERE interface_line_id = PLI.interface_line_id
1814: GROUP BY line_num
1815: HAVING Count(line_num) = 1 ) ;
1816: --CLM Phase 2 Autocreate Changes start

Line 1823: FROM po_lines_interface PLI,po_lines_draft_all pla

1819:
1820: CURSOR cur_target_lines(p_intf_line_id NUMBER)
1821: IS
1822: SELECT pla.po_line_id
1823: FROM po_lines_interface PLI,po_lines_draft_all pla
1824: WHERE PLI.interface_header_id = po_autocreate_params.g_interface_header_id
1825: AND PLI.interface_line_id = p_intf_line_id
1826: AND PLI.line_num = pla.line_num
1827: AND pla.draft_id = po_autocreate_params.g_draft_id;

Line 2726: FROM po_lines_draft_all pld, po_lines_interface PLI

2722:
2723: CURSOR c_lines
2724: IS
2725: SELECT pld.po_line_id
2726: FROM po_lines_draft_all pld, po_lines_interface PLI
2727: WHERE
2728: --bug 13640946 commenting out the condition as template_id has been stamped in the drafts table before making thisa uda call.
2729: --pld.uda_template_id IS NULL AND
2730: PLI.interface_header_id = po_autocreate_params.g_interface_header_id

Line 2739: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll

2735:
2736: CURSOR c_shipments
2737: IS
2738: SELECT pll.line_location_id
2739: FROM po_lines_draft_all pld, po_lines_interface PLI, po_line_locations_draft_all pll
2740: WHERE
2741: --bug 13640946 commenting out the condition as template_id has been stamped in the drafts table before making thisa uda call.
2742: --pll.uda_template_id IS NULL AND
2743: PLI.interface_header_id = po_autocreate_params.g_interface_header_id

Line 3222: -- We can get the source document details from po_lines_interface

3218: -- If we know the interface header id we can find out whether the call is
3219: -- from sourcing or PO BWC and also we can find out the target document style
3220: -- and document type, subtype etc..
3221: -- PO_HEADERS_INTERFACE.interface_source_code,document_type_code,document_subtype,style_id
3222: -- We can get the source document details from po_lines_interface
3223:
3224: -- Initialize source and target functional,document type, document style details.
3225:
3226: l_progress := '010';