APPS.OKS_IBINT_PUB dependencies on OE_ORDER_LINES_ALL

Line 24: from csi_item_instances csi , oe_order_lines_all ol

20: Return BOOLEAN
21: IS
22: CURSOR l_parent_cp_csr IS
23: Select csi.instance_id
24: from csi_item_instances csi , oe_order_lines_all ol
25: where ol.line_id = csi.last_oe_order_line_id
26: and ol.inventory_item_id = csi.inventory_item_id
27: and ol.line_id = p_order_line_id ;
28:

Line 346: from oe_order_lines_all

342: Cursor l_org_csr (p_line_id Number) Is
343: select org_id
344: ,sold_from_org_id
345: ,ship_from_org_id
346: from oe_order_lines_all
347: where Line_id = p_line_id;
348:
349: Cursor l_organization_csr(p_org_id Number) Is
350: Select master_organization_id

Line 385: OE_ORDER_LINES_ALL OL

381: Select csi.last_oe_agreement_id Product_agreement_id
382: ,oh.transactional_curr_code Original_order_currency_code
383: From CSI_ITEM_INSTANCES Csi,
384: OE_ORDER_HEADERS_ALL OH,
385: OE_ORDER_LINES_ALL OL
386: Where csi.instance_id = p_id
387: And csi.last_oe_order_line_id = ol.line_id
388: And oh.header_id = ol.header_id;
389:

Line 464: OE_ORDER_LINES_ALL OL

460: -- the GCD rules for sold to customer
461: Cursor l_Ord_Hdr_csr(p_line_id NUMBER) Is
462: Select OH.SOLD_TO_ORG_ID
463: From OE_Order_Headers_ALL OH,
464: OE_ORDER_LINES_ALL OL
465: Where OH.Header_id = OL.Header_id
466: AND OL.line_id = p_line_id;
467:
468: l_item_id Number;