APPS.INV_INVSTMVT_XMLP_PKG dependencies on MTL_MOVEMENT_STATISTICS

Line 845: MTL_MOVEMENT_STATISTICS

841: BEGIN
842: IF P_REPORT_OPTION = 'O/S' THEN
843: IF CS_NO_COUNT <> 0 THEN
844: UPDATE
845: MTL_MOVEMENT_STATISTICS
846: SET
847: MOVEMENT_STATUS = 'F'
848: ,REPORT_REFERENCE = TO_CHAR(P_LEGAL_ENTITY_ID) || P_ZONE_CODE || P_PERIOD_NAME || P_USAGE_TYPE || P_STAT_TYPE || P_MOVEMENT_TYPE
849: WHERE ENTITY_ORG_ID = P_LEGAL_ENTITY_ID

Line 1187: MTL_MOVEMENT_STATISTICS mms

1183: COUNT(*)
1184: INTO
1185: l_nnverified_status_count
1186: FROM
1187: MTL_MOVEMENT_STATISTICS mms
1188: WHERE mms.entity_org_id = p_legal_entity_id
1189: AND mms.zone_code = p_zone_code
1190: AND mms.period_name = p_period_name
1191: AND mms.usage_type = p_usage_type

Line 1411: Fix bug 2230047, get commodity code from mtl_movement_statistics table directly

1407: END;
1408:
1409:
1410: /*
1411: Fix bug 2230047, get commodity code from mtl_movement_statistics table directly
1412: not use flexfield anymore
1413: ------------------------------------------------
1414: -- Initialization for Commodity Structure id --
1415: -- of one Legal Entity --

Line 1452: Fix bug 2230047, get commodity code from mtl_movement_statistics table directly

1448: SRW.Message(31, 'Failed in ITEM Flexfield');
1449: END;
1450: */
1451: /*
1452: Fix bug 2230047, get commodity code from mtl_movement_statistics table directly
1453: not use flexfield anymore
1454: ----------------------------------
1455: -- Flexfield for COMMODITY_CODE --
1456: ----------------------------------

Line 1548: from mtl_movement_statistics

1544: THEN
1545: P_MVT_ID_WHERE := 'and mms.parent_movement_id = mms.movement_id';
1546: ELSE
1547: P_MVT_ID_WHERE :='and movement_id = (select min(movement_id)
1548: from mtl_movement_statistics
1549: where parent_movement_id = mms.parent_movement_id
1550: and movement_type = '''||P_MOVEMENT_TYPE||''' group by mms.parent_movement_id)';
1551:
1552: END IF;