APPS.INV_INVTRHAN_XMLP_PKG dependencies on CST_ITEM_COSTS_FOR_GL_VIEW

Line 541: cst_item_costs_for_gl_view cst

537: -sum(primary_quantity) target_qty
538: from mtl_material_transactions mmt,
539: mtl_txn_source_types mtst,
540: mtl_parameters mp,
541: cst_item_costs_for_gl_view cst
542: where mmt.organization_id = ' || VAR_ORG || '
543: and mp.organization_id = ' || VAR_ORG || '
544: and cst.organization_id = ' || VAR_ORG || '
545: and cst.inventory_item_id = mmt.inventory_item_id

Line 797: CST_ITEM_COSTS_FOR_GL_VIEW

793: SELECT
794: ITEM_COST
795: INTO CURRENT_ITEM_COST
796: FROM
797: CST_ITEM_COSTS_FOR_GL_VIEW
798: WHERE ORGANIZATION_ID = P_ORG_ID
799: AND INVENTORY_ITEM_ID = ITEM_ID;
800: EXCEPTION
801: WHEN NO_DATA_FOUND THEN

Line 913: CST_ITEM_COSTS_FOR_GL_VIEW

909: SELECT
910: ITEM_COST
911: INTO CURRENT_ITEM_COST
912: FROM
913: CST_ITEM_COSTS_FOR_GL_VIEW
914: WHERE ORGANIZATION_ID = P_ORG_ID
915: AND INVENTORY_ITEM_ID = ITEM_ID;
916: MY_OTHERS := NVL(OTHER
917: ,0);

Line 1011: CST_ITEM_COSTS_FOR_GL_VIEW

1007: SELECT
1008: ITEM_COST
1009: INTO CURRENT_ITEM_COST
1010: FROM
1011: CST_ITEM_COSTS_FOR_GL_VIEW
1012: WHERE ORGANIZATION_ID = P_ORG_ID
1013: AND INVENTORY_ITEM_ID = ITEM_ID;
1014: MY_OTHERS := NVL(OTHER
1015: ,0);

Line 1109: CST_ITEM_COSTS_FOR_GL_VIEW

1105: SELECT
1106: ITEM_COST
1107: INTO CURRENT_ITEM_COST
1108: FROM
1109: CST_ITEM_COSTS_FOR_GL_VIEW
1110: WHERE ORGANIZATION_ID = P_ORG_ID
1111: AND INVENTORY_ITEM_ID = ITEM_ID;
1112: MY_OTHERS := NVL(OTHER
1113: ,0);

Line 1207: CST_ITEM_COSTS_FOR_GL_VIEW

1203: SELECT
1204: ITEM_COST
1205: INTO CURRENT_ITEM_COST
1206: FROM
1207: CST_ITEM_COSTS_FOR_GL_VIEW
1208: WHERE ORGANIZATION_ID = P_ORG_ID
1209: AND INVENTORY_ITEM_ID = ITEM_ID;
1210: MY_OTHERS := NVL(OTHER
1211: ,0);