APPS.OE_FLEX_COGS_PUB dependencies on OE_ORDER_LINES

Line 137: FROM OE_ORDER_LINES

133: ORG_ID --14374856
134: INTO l_reference_line_id,
135: l_line_category_code,
136: l_lin_org --14374856
137: FROM OE_ORDER_LINES
138: WHERE LINE_ID = p_line_id;
139:
140: EXCEPTION
141:

Line 204: FROM OE_ORDER_LINES

200: l_change_sequence,
201: l_source_document_type_id,
202: l_source_document_id,
203: l_source_document_line_id
204: FROM OE_ORDER_LINES
205: WHERE LINE_ID = l_line_id;
206:
207: -- Exception Management begin Set message context
208: OE_MSG_PUB.set_msg_context(

Line 554: FROM OE_ORDER_LINES

550: SELECT LINK_TO_LINE_ID,
551: ITEM_TYPE_CODE
552: INTO l_link_to_line_id,
553: l_item_type_code
554: FROM OE_ORDER_LINES
555: WHERE LINE_ID = l_line_id;
556:
557: l_cost_sale_item_derived := NULL;
558:

Line 563: FROM OE_ORDER_LINES OL,

559: IF l_line_id IS NOT NULL THEN
560: BEGIN
561: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
562: INTO l_cost_sale_item_derived
563: FROM OE_ORDER_LINES OL,
564: MTL_SYSTEM_ITEMS M
565: WHERE OL.LINE_ID = l_line_id
566: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
567: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line 598: FROM OE_ORDER_LINES OL,

594: BEGIN
595:
596: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
597: INTO l_cost_sale_item_derived
598: FROM OE_ORDER_LINES OL,
599: MTL_SYSTEM_ITEMS M
600: WHERE OL.LINE_ID = l_link_to_line_id
601: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
602: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line 720: FROM OE_ORDER_LINES

716: SHIP_FROM_ORG_ID
717: INTO l_top_model_line_id,
718: l_inventory_item_id,
719: l_ship_from_org_id
720: FROM OE_ORDER_LINES
721: WHERE LINE_ID = l_line_id;
722:
723: l_model_line_id := l_top_model_line_id;
724: l_organization_id := l_ship_from_org_id;

Line 734: FROM OE_ORDER_LINES OL,

730: IF (l_model_line_id IS NOT NULL) THEN
731: BEGIN
732: SELECT NVL(M.COST_OF_SALES_ACCOUNT,0)
733: INTO l_cost_sale_model_derived
734: FROM OE_ORDER_LINES OL,
735: MTL_SYSTEM_ITEMS M
736: WHERE OL.LINE_ID = l_model_line_id
737: AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
738: AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line 1061: From oe_order_lines_all

1057: BEGIN
1058:
1059: Select line_type_id
1060: Into l_order_type_id
1061: From oe_order_lines_all
1062: Where line_id = l_order_line_id;
1063:
1064: EXCEPTION
1065: WHEN NO_DATA_FOUND THEN

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

1067: --FND_MESSAGE.SET_TOKEN('LINEID',l_order_line_id);
1068: --fb_error_msg := FND_MESSAGE.GET_ENCODED;
1069: --FND_MESSAGE.SET_ENCODED(fb_error_msg);
1070: --l_error_msg := FND_MESSAGE.GET;
1071: wf_engine.setItemAttrText(itemtype,itemkey,'ERROR_MESSAGE','No line type id found in oe_order_lines_all');
1072: result := 'COMPLETE:FAILURE';
1073: RETURN;
1074:
1075: END;