DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OE_ORDER_LINES_ALL

Line 1005: FROM csi_item_instances csi, oe_order_lines_all ol

1001: SELECT DECODE (ol.actual_shipment_date,
1002: NULL, 'N',
1003: 'Y'
1004: ) shipped_flag
1005: FROM csi_item_instances csi, oe_order_lines_all ol
1006: WHERE csi.instance_id = p_customer_product_id
1007: AND csi.last_oe_order_line_id = ol.line_id;
1008:
1009: /* fix for bug#6047047 -- fp of bug#5939487 */

Line 1917: FROM oe_order_lines_all ol

1913: ol.tax_point_code,
1914: ol.tax_exempt_flag,
1915: ol.header_id
1916: --
1917: FROM oe_order_lines_all ol
1918: WHERE ol.line_id = l_line_id;
1919:
1920: CURSOR l_segment_csr (p_org_id NUMBER)
1921: IS

Line 2158: FROM oe_order_lines_all ol,

2154: ol.tax_exempt_number, -- Bug#5008188 - vjramali
2155: ol.tax_exempt_reason_code,
2156: ol.tax_code, ol.tax_exempt_flag, -- End Bug#5008188
2157: b.contract_item_type_code ----Added for ER 16039680
2158: FROM oe_order_lines_all ol,
2159: mtl_system_items_b_kfv b,
2160: mtl_system_items_tl t
2161: WHERE ol.line_id = p_order_line_id
2162: AND b.inventory_item_id = ol.inventory_item_id

Line 2171: FROM oe_order_lines_all

2167:
2168: CURSOR get_csr_order_line_id (p_service_line_id NUMBER)
2169: IS
2170: SELECT actual_shipment_date
2171: FROM oe_order_lines_all
2172: WHERE line_id = p_service_line_id;
2173:
2174: -- Extwarranty cascading
2175: CURSOR get_warr_dates_csr

Line 2596: FROM oe_order_lines_all

2592: CURSOR l_line_csr (p_ord_hdr_id NUMBER)
2593: IS
2594: SELECT line_id, inventory_item_id, service_start_date,
2595: service_end_date, service_reference_line_id
2596: FROM oe_order_lines_all
2597: WHERE header_id = p_ord_hdr_id
2598: AND service_reference_line_id = p_order_line_id
2599: AND service_reference_type_code IS NOT NULL;
2600: BEGIN

Line 2715: From OE_ORDER_LINES_ALL

2711: ,Service_Start_Date
2712: ,Service_End_Date
2713: ,Inventory_Item_Id
2714: ,Service_Reference_Line_Id
2715: From OE_ORDER_LINES_ALL
2716: Where not HEADER_ID = p_ord_hdr_id
2717: And Service_reference_type_code = 'ORDER'
2718: And Service_Reference_line_id = p_order_line_id
2719: And Service_Duration is Not Null;

Line 2725: FROM oe_order_lines_all

2721: CURSOR l_line_serv_csr (p_ord_hdr_id NUMBER)
2722: IS
2723: SELECT line_id, service_start_date, service_end_date,
2724: inventory_item_id, service_reference_line_id
2725: FROM oe_order_lines_all
2726: WHERE header_id = p_ord_hdr_id
2727: AND service_reference_type_code = 'CUSTOMER_PRODUCT'
2728: AND service_reference_line_id = p_customer_product_id
2729: AND service_duration IS NOT NULL;

Line 3740: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL

3736: IS
3737: SELECT ol.header_id, oh.transactional_curr_code, oh.cust_po_number,
3738: oh.invoice_to_contact_id, oh.agreement_id,
3739: oh.invoicing_rule_id, oh.accounting_rule_id
3740: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL
3741: ,
3742: oe_order_headers_all oh -- OKX_ORDER_HEADERS_V OH
3743: WHERE ol.line_id = p_line_id AND ol.header_id = oh.header_id;
3744: