APPS.INV_INVSTMVT_XMLP_PKG dependencies on MTL_MOVEMENT_STATISTICS

Line 849: MTL_MOVEMENT_STATISTICS

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

Line 1193: MTL_MOVEMENT_STATISTICS mms

1189: COUNT(*)
1190: INTO
1191: l_nnverified_status_count
1192: FROM
1193: MTL_MOVEMENT_STATISTICS mms
1194: WHERE mms.entity_org_id = p_legal_entity_id
1195: AND mms.zone_code = p_zone_code
1196: AND mms.period_name = p_period_name
1197: AND mms.usage_type = p_usage_type

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

1413: END;
1414:
1415:
1416: /*
1417: Fix bug 2230047, get commodity code from mtl_movement_statistics table directly
1418: not use flexfield anymore
1419: ------------------------------------------------
1420: -- Initialization for Commodity Structure id --
1421: -- of one Legal Entity --

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

1454: SRW.Message(31, 'Failed in ITEM Flexfield');
1455: END;
1456: */
1457: /*
1458: Fix bug 2230047, get commodity code from mtl_movement_statistics table directly
1459: not use flexfield anymore
1460: ----------------------------------
1461: -- Flexfield for COMMODITY_CODE --
1462: ----------------------------------

Line 1554: from mtl_movement_statistics

1550: THEN
1551: P_MVT_ID_WHERE := 'and mms.parent_movement_id = mms.movement_id';
1552: ELSE
1553: P_MVT_ID_WHERE :='and movement_id = (select min(movement_id)
1554: from mtl_movement_statistics
1555: where parent_movement_id = mms.parent_movement_id
1556: and movement_type = '''||P_MOVEMENT_TYPE||''' group by mms.parent_movement_id)';
1557:
1558: END IF;