eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_PVT dependencies on MTL_ITEM_REVISIONS_B

Line 811: FROM MTL_ITEM_REVISIONS_B R

807: FROM MTL_PARAMETERS P
808: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
809: ),
810: ( SELECT ORGANIZATION_ID
811: FROM MTL_ITEM_REVISIONS_B R
812: WHERE R.REVISION_ID = EIUAI.REVISION_ID
813: ),
814: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
815: )

Line 818: FROM MTL_ITEM_REVISIONS_B r

814: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
815: )
816: , NVL( eiuai.REVISION,
817: ( SELECT r.REVISION
818: FROM MTL_ITEM_REVISIONS_B r
819: WHERE r.REVISION_ID = eiuai.REVISION_ID
820: )
821: )
822: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 835: FROM MTL_ITEM_REVISIONS_B R

831: FROM MTL_PARAMETERS P
832: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
833: ),
834: ( SELECT ORGANIZATION_ID
835: FROM MTL_ITEM_REVISIONS_B R
836: WHERE R.REVISION_ID = EIUAI.REVISION_ID
837: ),
838: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
839: )

Line 842: FROM MTL_ITEM_REVISIONS_B r

838: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
839: )
840: , NVL( eiuai.REVISION,
841: ( SELECT r.REVISION
842: FROM MTL_ITEM_REVISIONS_B r
843: WHERE r.REVISION_ID = eiuai.REVISION_ID
844: )
845: )
846: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 895: FROM MTL_ITEM_REVISIONS_B R

891: FROM MTL_PARAMETERS P
892: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
893: ),
894: ( SELECT ORGANIZATION_ID
895: FROM MTL_ITEM_REVISIONS_B R
896: WHERE R.REVISION_ID = EIUAI.REVISION_ID
897: ),
898: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
899: )

Line 902: FROM MTL_ITEM_REVISIONS_B r

898: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
899: )
900: , NVL( eiuai.REVISION,
901: ( SELECT r.REVISION
902: FROM MTL_ITEM_REVISIONS_B r
903: WHERE r.REVISION_ID = eiuai.REVISION_ID
904: )
905: )
906: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 920: FROM MTL_ITEM_REVISIONS_B R

916: FROM MTL_PARAMETERS P
917: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
918: ),
919: ( SELECT ORGANIZATION_ID
920: FROM MTL_ITEM_REVISIONS_B R
921: WHERE R.REVISION_ID = EIUAI.REVISION_ID
922: ),
923: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
924: )

Line 927: FROM MTL_ITEM_REVISIONS_B r

923: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
924: )
925: , NVL( eiuai.REVISION,
926: ( SELECT r.REVISION
927: FROM MTL_ITEM_REVISIONS_B r
928: WHERE r.REVISION_ID = eiuai.REVISION_ID
929: )
930: )
931: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 2571: FROM MTL_ITEM_REVISIONS_B r

2567: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
2568:
2569: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
2570: SET REVISION = NVL( ( SELECT r.REVISION
2571: FROM MTL_ITEM_REVISIONS_B r
2572: WHERE r.REVISION_ID = miri.REVISION_ID
2573: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID
2574: )
2575: , REVISION

Line 3803: FROM MTL_ITEM_REVISIONS_B r

3799: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
3800:
3801: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
3802: SET REVISION = NVL( ( SELECT r.REVISION
3803: FROM MTL_ITEM_REVISIONS_B r
3804: WHERE r.REVISION_ID = miri.REVISION_ID
3805: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID
3806: )
3807: , REVISION

Line 6028: Upper(REVISION) NOT IN ( SELECT B.REVISION FROM MTL_ITEM_REVISIONS_B B, MTL_SYSTEM_ITEMS_INTERFACE MSII

6024: SOURCE_SYSTEM_ID = p_source_system_id AND
6025: SOURCE_SYSTEM_REFERENCE = p_source_system_reference AND
6026: (ORGANIZATION_ID = p_organization_id OR ORGANIZATION_CODE = p_organization_code) AND
6027: REVISION IS NOT NULL AND
6028: Upper(REVISION) NOT IN ( SELECT B.REVISION FROM MTL_ITEM_REVISIONS_B B, MTL_SYSTEM_ITEMS_INTERFACE MSII
6029: WHERE MSII.SOURCE_SYSTEM_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
6030: AND MSII.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
6031: AND (MSII.ORGANIZATION_ID = MIRI.ORGANIZATION_ID
6032: OR MSII.ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)

Line 7545: FROM MTL_ITEM_REVISIONS_B R

7541: AND ITEM_NUMBER IS NULL;
7542:
7543: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7544: SET REVISION = ( SELECT R.REVISION
7545: FROM MTL_ITEM_REVISIONS_B R
7546: WHERE R.REVISION_ID = eiuai.REVISION_ID
7547: )
7548: WHERE DATA_SET_ID = p_batch_id
7549: AND PROCESS_STATUS = p_process_status

Line 7921: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;

7917: l_err_text VARCHAR2(4000);
7918: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
7919: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;
7920: l_item_id NUMBER;
7921: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
7922: l_error BOOLEAN;
7923: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
7924:
7925: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

Line 8186: FROM MTL_ITEM_REVISIONS_B MIR

8182: WHEN MSII.CONFIRM_STATUS = 'CN'
8183: THEN 'CREATE'
8184: WHEN (MSII.CONFIRM_STATUS IN ( 'CM', 'CC', G_CONF_XREF_FAKE, G_CONF_MATCH_FAKE )
8185: AND EXISTS (SELECT NULL
8186: FROM MTL_ITEM_REVISIONS_B MIR
8187: WHERE MIR.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
8188: AND MIR.ORGANIZATION_ID = MIRI.ORGANIZATION_ID
8189: AND MIR.REVISION = MIRI.REVISION) )
8190: THEN 'UPDATE'

Line 8581: FROM MTL_ITEM_REVISIONS_B MIR

8577: THEN 'CREATE'
8578: WHEN MIRI.TRANSACTION_TYPE <> 'SYNC'
8579: THEN MIRI.TRANSACTION_TYPE
8580: WHEN EXISTS (SELECT 1
8581: FROM MTL_ITEM_REVISIONS_B MIR
8582: WHERE MIR.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
8583: AND MIR.ORGANIZATION_ID = MIRI.ORGANIZATION_ID
8584: AND MIR.REVISION = MIRI.REVISION)
8585: THEN 'UPDATE'

Line 8702: FROM MTL_ITEM_REVISIONS_B

8698: AND MSII.ORGANIZATION_ID = l_org_id
8699: )
8700: WHEN '1'
8701: THEN (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC)
8702: FROM MTL_ITEM_REVISIONS_B
8703: WHERE INVENTORY_ITEM_ID = ATTRS.INVENTORY_ITEM_ID
8704: AND ORGANIZATION_ID = ATTRS.ORGANIZATION_ID)
8705: WHEN '2'
8706: THEN (SELECT REVISION

Line 8759: FROM MTL_ITEM_REVISIONS_B

8755: AND MSII.SOURCE_SYSTEM_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
8756: AND MSII.ORGANIZATION_ID = l_org_id)
8757: )
8758: THEN (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC)
8759: FROM MTL_ITEM_REVISIONS_B
8760: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID
8761: AND ORGANIZATION_ID = MIRI.ORGANIZATION_ID)
8762: WHEN (EXISTS (SELECT NULL
8763: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

Line 9009: FROM MTL_ITEM_REVISIONS_B

9005: l_sql := q'#
9006: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
9007: SET (REVISION, TRANSACTION_TYPE) =
9008: (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC), 'UPDATE'
9009: FROM MTL_ITEM_REVISIONS_B
9010: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID
9011: AND ORGANIZATION_ID = MIRI.ORGANIZATION_ID)
9012: WHERE MIRI.SET_PROCESS_ID = :p_data_set_id
9013: AND MIRI.PROCESS_FLAG = 1