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_AUTOCREATE_GROUPING_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 73: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,

69: x_token_value OUT NOCOPY VARCHAR2
70: );
71:
72: TYPE line_info IS RECORD(
73: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,

Line 74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,

70: );
71:
72: TYPE line_info IS RECORD(
73: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,

Line 75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,

71:
72: TYPE line_info IS RECORD(
73: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,

Line 76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,

72: TYPE line_info IS RECORD(
73: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,

Line 77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,

73: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,

Line 78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,

74: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

Line 79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,

75: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

Line 80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,

76: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,

Line 81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,

77: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,

Line 82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

78: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
86: closed_code PO_LINES_ALL.closed_code%TYPE,

Line 83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

79: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
80: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
81: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
82: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
86: closed_code PO_LINES_ALL.closed_code%TYPE,
87: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE

Line 87: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE

83: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
84: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
85: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
86: closed_code PO_LINES_ALL.closed_code%TYPE,
87: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
88: );
89:
90: FUNCTION get_req_line_info(p_req_line_id IN NUMBER) RETURN LINE_INFO;
91:

Line 340: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;

336: d_position NUMBER := 0;
337:
338: l_num_lines NUMBER;
339: l_key NUMBER;
340: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
341: l_po_line_num PO_LINES_ALL.line_num%TYPE;
342: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
343: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
344: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;

Line 342: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;

338: l_num_lines NUMBER;
339: l_key NUMBER;
340: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
341: l_po_line_num PO_LINES_ALL.line_num%TYPE;
342: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
343: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
344: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
345: l_message_code VARCHAR2(30) := NULL;
346: l_token_name VARCHAR2(30) := NULL;

Line 1223: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;

1219: d_mod CONSTANT VARCHAR2(100) := D_get_req_line_delivery_info;
1220: d_position NUMBER := 0;
1221:
1222: l_req_line_delivery_info PO_DELIVERY_INFO_CSR%ROWTYPE;
1223: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
1224: BEGIN
1225: IF (PO_LOG.d_proc) THEN
1226: PO_LOG.proc_begin(d_mod);
1227: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

Line 1240: FROM po_requisition_lines_all PRL

1236: INTO l_item_id,
1237: l_req_line_delivery_info.need_by_date,
1238: l_req_line_delivery_info.ship_to_organization_id,
1239: l_req_line_delivery_info.ship_to_location_id
1240: FROM po_requisition_lines_all PRL
1241: WHERE PRL.requisition_line_id = p_req_line_id;
1242:
1243: l_req_line_delivery_info.consigned_flag :=
1244: PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag(

Line 1446: FROM po_requisition_lines_all PRL,

1442: NULL, -- cancel flag N/A for req line
1443: NULL, -- closed code N/A for req line
1444: PRL.supplier_ref_number
1445: INTO l_req_line_info
1446: FROM po_requisition_lines_all PRL,
1447: po_lines_all SRC_DOC_LINE
1448: WHERE PRL.requisition_line_id = p_req_line_id
1449: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
1450: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;

Line 2205: FROM po_requisition_lines_all

2201: d_position := 10;
2202:
2203: SELECT requisition_header_id
2204: INTO l_req_header_id
2205: FROM po_requisition_lines_all
2206: WHERE requisition_line_id = p_req_line_id_tbl(i);
2207:
2208: d_position := 20;
2209:

Line 2348: FROM po_requisition_lines_all prl

2344: SELECT DISTINCT
2345: l_key
2346: , prl.requisition_line_id
2347: , pol.line_num
2348: FROM po_requisition_lines_all prl
2349: , po_lines_all pol
2350: , po_line_locations_all pll
2351: , po_lines_all src_line
2352: WHERE pol.po_header_id = p_add_to_po_header_id

Line 2704: FROM po_requisition_lines_all

2700: FOR i IN 1..p_req_line_id_tbl.COUNT LOOP
2701:
2702: SELECT item_id
2703: INTO l_item_id
2704: FROM po_requisition_lines_all
2705: WHERE requisition_line_id = p_req_line_id_tbl(i);
2706:
2707: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_item_id',l_item_id); END IF;
2708: