DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_LINES_ALL

Line 430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;

426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
432:
433: --bug5841426
434:

Line 2141: , po_lines_all POL

2137: , PD.last_update_date
2138: , PD.last_updated_by
2139: , PD.last_update_login
2140: FROM po_price_differentials PD
2141: , po_lines_all POL
2142: WHERE PD.entity_type = 'BLANKET LINE'
2143: AND PD.entity_id = POL.po_line_id
2144: AND POL.po_header_id = p_po_header_id;
2145:

Line 2177: , po_lines_all POL

2173: , PD.last_update_date
2174: , PD.last_updated_by
2175: , PD.last_update_login
2176: FROM po_price_differentials PD
2177: , po_lines_all POL
2178: , po_line_locations_all POLL
2179: WHERE PD.entity_type = 'PRICE BREAK'
2180: AND PD.entity_id = POLL.line_location_id
2181: AND POLL.po_line_id = POL.po_line_id

Line 2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;

2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
2495: x_req_in_pool_flag VARCHAR2(1) :=NULL;
2496: x_cancel_flag varchar2(1);
2497: x_closed_code varchar2(25);