APPS.OE_FLEX_COGS_PUB dependencies on OE_ORDER_LINES

Line 133: FROM OE_ORDER_LINES

129: SELECT REFERENCE_LINE_ID,
130: LINE_CATEGORY_CODE
131: INTO l_reference_line_id,
132: l_line_category_code
133: FROM OE_ORDER_LINES
134: WHERE LINE_ID = p_line_id;
135:
136: EXCEPTION
137:

Line 190: FROM OE_ORDER_LINES

186: l_change_sequence,
187: l_source_document_type_id,
188: l_source_document_id,
189: l_source_document_line_id
190: FROM OE_ORDER_LINES
191: WHERE LINE_ID = l_line_id;
192:
193: -- Exception Management begin Set message context
194: OE_MSG_PUB.set_msg_context(

Line 540: FROM OE_ORDER_LINES

536: SELECT LINK_TO_LINE_ID,
537: ITEM_TYPE_CODE
538: INTO l_link_to_line_id,
539: l_item_type_code
540: FROM OE_ORDER_LINES
541: WHERE LINE_ID = l_line_id;
542:
543: l_cost_sale_item_derived := NULL;
544:

Line 549: FROM OE_ORDER_LINES OL,

545: IF l_line_id IS NOT NULL THEN
546: BEGIN
547: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
548: INTO l_cost_sale_item_derived
549: FROM OE_ORDER_LINES OL,
550: MTL_SYSTEM_ITEMS M
551: WHERE OL.LINE_ID = l_line_id
552: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
553: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line 584: FROM OE_ORDER_LINES OL,

580: BEGIN
581:
582: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
583: INTO l_cost_sale_item_derived
584: FROM OE_ORDER_LINES OL,
585: MTL_SYSTEM_ITEMS M
586: WHERE OL.LINE_ID = l_link_to_line_id
587: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
588: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line 706: FROM OE_ORDER_LINES

702: SHIP_FROM_ORG_ID
703: INTO l_top_model_line_id,
704: l_inventory_item_id,
705: l_ship_from_org_id
706: FROM OE_ORDER_LINES
707: WHERE LINE_ID = l_line_id;
708:
709: l_model_line_id := l_top_model_line_id;
710: l_organization_id := l_ship_from_org_id;

Line 720: FROM OE_ORDER_LINES OL,

716: IF (l_model_line_id IS NOT NULL) THEN
717: BEGIN
718: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
719: INTO l_cost_sale_model_derived
720: FROM OE_ORDER_LINES OL,
721: MTL_SYSTEM_ITEMS M
722: WHERE OL.LINE_ID = l_model_line_id
723: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
724: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line 1047: From oe_order_lines_all

1043: BEGIN
1044:
1045: Select line_type_id
1046: Into l_order_type_id
1047: From oe_order_lines_all
1048: Where line_id = l_order_line_id;
1049:
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN

Line 1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');

1053: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1054: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1055: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1056: --l_error_msg := FND_MESSAGE.GET;
1057: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1058: result := 'COMPLETE:FAILURE';
1059: RETURN;
1060:
1061: END;