DBA Data[Home] [Help]

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 342: from oe_order_lines_all

338: Cursor l_org_csr (p_line_id Number) Is
339: select org_id
340: ,sold_from_org_id
341: ,ship_from_org_id
342: from oe_order_lines_all
343: where Line_id = p_line_id;
344:
345: Cursor l_organization_csr(p_org_id Number) Is
346: Select master_organization_id

Line 381: OE_ORDER_LINES_ALL OL

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

Line 460: OE_ORDER_LINES_ALL OL

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

Line 3533: OE_ORDER_LINES_ALL OOL,

3529: IS
3530: SELECT 'Y'
3531: FROM CSI_ITEM_INSTANCES CII,
3532: CSI_I_ORG_ASSIGNMENTS CIOA,
3533: OE_ORDER_LINES_ALL OOL,
3534: OKC_K_PARTY_ROLES_B k_party,
3535: okc_k_headers_all_b okh
3536: WHERE CII.last_oe_order_line_id = OOL.line_id( + )
3537: AND CII.instance_id = CIOA.instance_id( + )