APPS.OKS_EXTWAR_UTIL_PVT dependencies on OE_ORDER_LINES_ALL

Line 1004: FROM csi_item_instances csi, oe_order_lines_all ol

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

Line 1913: FROM oe_order_lines_all ol

1909: ol.tax_point_code,
1910: ol.tax_exempt_flag,
1911: ol.header_id
1912: --
1913: FROM oe_order_lines_all ol
1914: WHERE ol.line_id = l_line_id;
1915:
1916: CURSOR l_segment_csr (p_org_id NUMBER)
1917: IS

Line 2153: FROM oe_order_lines_all ol,

2149: ol.header_id,
2150: ol.tax_exempt_number, -- Bug#5008188 - vjramali
2151: ol.tax_exempt_reason_code,
2152: ol.tax_code, ol.tax_exempt_flag -- End Bug#5008188
2153: FROM oe_order_lines_all ol,
2154: mtl_system_items_b_kfv b,
2155: mtl_system_items_tl t
2156: WHERE ol.line_id = p_order_line_id
2157: AND b.inventory_item_id = ol.inventory_item_id

Line 2166: FROM oe_order_lines_all

2162:
2163: CURSOR get_csr_order_line_id (p_service_line_id NUMBER)
2164: IS
2165: SELECT actual_shipment_date
2166: FROM oe_order_lines_all
2167: WHERE line_id = p_service_line_id;
2168:
2169: -- Extwarranty cascading
2170: CURSOR get_warr_dates_csr

Line 2550: FROM oe_order_lines_all

2546: CURSOR l_line_csr (p_ord_hdr_id NUMBER)
2547: IS
2548: SELECT line_id, inventory_item_id, service_start_date,
2549: service_end_date, service_reference_line_id
2550: FROM oe_order_lines_all
2551: WHERE header_id = p_ord_hdr_id
2552: AND service_reference_line_id = p_order_line_id
2553: AND service_reference_type_code IS NOT NULL;
2554: BEGIN

Line 2669: From OE_ORDER_LINES_ALL

2665: ,Service_Start_Date
2666: ,Service_End_Date
2667: ,Inventory_Item_Id
2668: ,Service_Reference_Line_Id
2669: From OE_ORDER_LINES_ALL
2670: Where not HEADER_ID = p_ord_hdr_id
2671: And Service_reference_type_code = 'ORDER'
2672: And Service_Reference_line_id = p_order_line_id
2673: And Service_Duration is Not Null;

Line 2679: FROM oe_order_lines_all

2675: CURSOR l_line_serv_csr (p_ord_hdr_id NUMBER)
2676: IS
2677: SELECT line_id, service_start_date, service_end_date,
2678: inventory_item_id, service_reference_line_id
2679: FROM oe_order_lines_all
2680: WHERE header_id = p_ord_hdr_id
2681: AND service_reference_type_code = 'CUSTOMER_PRODUCT'
2682: AND service_reference_line_id = p_customer_product_id
2683: AND service_duration IS NOT NULL;

Line 3694: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL

3690: IS
3691: SELECT ol.header_id, oh.transactional_curr_code, oh.cust_po_number,
3692: oh.invoice_to_contact_id, oh.agreement_id,
3693: oh.invoicing_rule_id, oh.accounting_rule_id
3694: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL
3695: ,
3696: oe_order_headers_all oh -- OKX_ORDER_HEADERS_V OH
3697: WHERE ol.line_id = p_line_id AND ol.header_id = oh.header_id;
3698: