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 94: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,

90: x_token_value OUT NOCOPY VARCHAR2
91: );
92:
93: TYPE line_info IS RECORD(
94: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,

Line 95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,

91: );
92:
93: TYPE line_info IS RECORD(
94: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,

Line 96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,

92:
93: TYPE line_info IS RECORD(
94: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,

Line 97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,

93: TYPE line_info IS RECORD(
94: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,

Line 98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,

94: item_id PO_REQUISITION_LINES_ALL.item_id%TYPE,
95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,

Line 99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,

95: item_description PO_REQUISITION_LINES_ALL.item_description%TYPE,
96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

Line 100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,

96: item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE,
97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

Line 101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,

97: order_type_lookup_code PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE,
98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,

Line 102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,

98: purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE,
99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,

Line 103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

99: matching_basis PO_REQUISITION_LINES_ALL.matching_basis%TYPE,
100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,

Line 104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,

100: preferred_grade PO_REQUISITION_LINES_ALL.preferred_grade%TYPE,
101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE

Line 108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE

104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE
111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,
112: category_id PO_REQUISITION_LINES_ALL.category_id%TYPE --bugfix#16097884

Line 109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE

105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE
111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,
112: category_id PO_REQUISITION_LINES_ALL.category_id%TYPE --bugfix#16097884
113: );

Line 110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE

106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE
111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,
112: category_id PO_REQUISITION_LINES_ALL.category_id%TYPE --bugfix#16097884
113: );
114:

Line 111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,

107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE
111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,
112: category_id PO_REQUISITION_LINES_ALL.category_id%TYPE --bugfix#16097884
113: );
114:
115: FUNCTION get_req_line_info(p_req_line_id IN NUMBER) RETURN LINE_INFO;

Line 112: category_id PO_REQUISITION_LINES_ALL.category_id%TYPE --bugfix#16097884

108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE
111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,
112: category_id PO_REQUISITION_LINES_ALL.category_id%TYPE --bugfix#16097884
113: );
114:
115: FUNCTION get_req_line_info(p_req_line_id IN NUMBER) RETURN LINE_INFO;
116:

Line 460: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;

456: d_position NUMBER := 0;
457:
458: l_num_lines NUMBER;
459: l_key NUMBER;
460: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
461: l_po_line_num PO_LINES_ALL.line_num%TYPE;
462: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
463: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
464: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;

Line 462: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;

458: l_num_lines NUMBER;
459: l_key NUMBER;
460: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
461: l_po_line_num PO_LINES_ALL.line_num%TYPE;
462: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
463: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
464: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
465: l_message_code VARCHAR2(30) := NULL;
466: l_token_name VARCHAR2(30) := NULL;

Line 716: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;

712: d_mod CONSTANT VARCHAR2(100) := D_check_neg_line_numbers;
713: d_position NUMBER := 0;
714:
715: l_num_lines NUMBER;
716: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
717: l_sol_line_num_disp PON_AUCTION_ITEM_PRICES_ALL.LINE_NUM_DISPLAY%TYPE;
718: l_sol_line_num PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
719: l_message_code VARCHAR2(30) := NULL;
720: l_token_name VARCHAR2(30) := NULL;

Line 722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;

718: l_sol_line_num PON_AUCTION_ITEM_PRICES_ALL.LINE_NUMBER%TYPE;
719: l_message_code VARCHAR2(30) := NULL;
720: l_token_name VARCHAR2(30) := NULL;
721: l_token_value VARCHAR2(2000) := NULL;
722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;

Line 723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;

719: l_message_code VARCHAR2(30) := NULL;
720: l_token_name VARCHAR2(30) := NULL;
721: l_token_value VARCHAR2(2000) := NULL;
722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;

Line 725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;

721: l_token_value VARCHAR2(2000) := NULL;
722: req_line_type_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;

Line 727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;

723: req_group_line_id PO_REQUISITION_LINES_ALL.line_type_id%TYPE;
724: sol_line_type_id PON_AUCTION_ITEM_PRICES_ALL.line_type_id%TYPE;
725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;

Line 729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;

725: req_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
726: sol_item_id PON_AUCTION_ITEM_PRICES_ALL.item_id%TYPE;
727: req_item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;
728: sol_item_revision PON_AUCTION_ITEM_PRICES_ALL.item_revision%TYPE;
729: req_category_id PO_REQUISITION_LINES_ALL.category_id%TYPE;
730: sol_category_id PON_AUCTION_ITEM_PRICES_ALL.category_id%TYPE;
731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;

Line 793: FROM po_requisition_lines_all prl,po_line_types_b plt, mtl_units_of_measure mom, po_lines_all pol

789: ,req_line_ip_category_id
790: ,req_line_uom
791: ,req_group_line_id
792: ,req_ship_to_location_id
793: FROM po_requisition_lines_all prl,po_line_types_b plt, mtl_units_of_measure mom, po_lines_all pol
794: WHERE prl.requisition_line_id = l_req_line_id
795: AND prl.line_type_id = plt.line_type_id
796: AND mom.unit_of_measure (+) = prl.unit_meas_lookup_code
797: AND pol.po_header_id(+) = prl.blanket_po_header_id AND pol.line_num(+) = prl.blanket_po_line_num;

Line 2701: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;

2697: d_mod CONSTANT VARCHAR2(100) := D_get_req_line_delivery_info;
2698: d_position NUMBER := 0;
2699:
2700: l_req_line_delivery_info PO_DELIVERY_INFO_CSR%ROWTYPE;
2701: l_item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;
2702: BEGIN
2703: IF (PO_LOG.d_proc) THEN
2704: PO_LOG.proc_begin(d_mod);
2705: PO_LOG.proc_begin(d_mod,'p_req_line_id',p_req_line_id);

Line 2718: FROM po_requisition_lines_all PRL

2714: INTO l_item_id,
2715: l_req_line_delivery_info.need_by_date,
2716: l_req_line_delivery_info.ship_to_organization_id,
2717: l_req_line_delivery_info.ship_to_location_id
2718: FROM po_requisition_lines_all PRL
2719: WHERE PRL.requisition_line_id = p_req_line_id;
2720:
2721: l_req_line_delivery_info.consigned_flag :=
2722: PO_THIRD_PARTY_STOCK_GRP.get_consigned_flag(

Line 2931: FROM po_requisition_lines_all PRL,

2927: , PRL.CLM_INFO_FLAG
2928: , PRL.CLM_BASE_LINE_NUM
2929: , PRL.category_id --bugfix#16097884
2930: INTO l_req_line_info
2931: FROM po_requisition_lines_all PRL,
2932: po_lines_all SRC_DOC_LINE
2933: WHERE PRL.requisition_line_id = p_req_line_id
2934: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
2935: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;

Line 4051: FROM po_requisition_lines_all

4047: d_position := 10;
4048:
4049: SELECT requisition_header_id
4050: INTO l_req_header_id
4051: FROM po_requisition_lines_all
4052: WHERE requisition_line_id = p_req_line_id_tbl(i);
4053:
4054: d_position := 20;
4055:

Line 4195: FROM po_requisition_lines_all prl

4191: SELECT DISTINCT
4192: l_key
4193: , prl.requisition_line_id
4194: , pol.line_num
4195: FROM po_requisition_lines_all prl
4196: , po_lines_merge_v pol
4197: , po_line_locations_merge_v pll
4198: , po_lines_merge_v src_line
4199: WHERE pol.po_header_id = p_add_to_po_header_id

Line 4348: FROM po_requisition_lines_all prl

4344: l_key
4345: , prl.requisition_line_id
4346: , pol.line_num
4347: , pol.line_num_display
4348: FROM po_requisition_lines_all prl
4349: , po_lines_merge_v pol
4350: , po_line_locations_merge_v pll
4351: , po_lines_merge_v src_line
4352: WHERE pol.po_header_id = p_add_to_po_header_id

Line 4889: FROM po_requisition_lines_all

4885: FOR i IN 1..p_req_line_id_tbl.COUNT LOOP
4886:
4887: SELECT item_id
4888: INTO l_item_id
4889: FROM po_requisition_lines_all
4890: WHERE requisition_line_id = p_req_line_id_tbl(i);
4891:
4892: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,d_position,'l_item_id',l_item_id); END IF;
4893:

Line 5032: FROM po_requisition_lines_all PRL

5028: BEGIN
5029:
5030: BEGIN
5031: SELECT 'Y' INTO l_is_info_fund_req_line
5032: FROM po_requisition_lines_all PRL
5033: WHERE
5034: prl.REQUISITION_LINE_ID = p_req_line_id and
5035: nvl(prl.clm_info_flag, 'N') = 'N' AND prl.group_line_id IS NULL AND EXISTS (SELECT 1
5036: FROM po_req_distributions_all prd1 WHERE prd1.requisition_line_id = prl.REQUISITION_LINE_ID