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 826: FROM MTL_ITEM_REVISIONS_B R

822: FROM MTL_PARAMETERS P
823: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
824: ),
825: ( SELECT ORGANIZATION_ID
826: FROM MTL_ITEM_REVISIONS_B R
827: WHERE R.REVISION_ID = EIUAI.REVISION_ID
828: ),
829: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
830: )

Line 833: FROM MTL_ITEM_REVISIONS_B r

829: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
830: )
831: , NVL( eiuai.REVISION,
832: ( SELECT r.REVISION
833: FROM MTL_ITEM_REVISIONS_B r
834: WHERE r.REVISION_ID = eiuai.REVISION_ID
835: )
836: )
837: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 850: FROM MTL_ITEM_REVISIONS_B R

846: FROM MTL_PARAMETERS P
847: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
848: ),
849: ( SELECT ORGANIZATION_ID
850: FROM MTL_ITEM_REVISIONS_B R
851: WHERE R.REVISION_ID = EIUAI.REVISION_ID
852: ),
853: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
854: )

Line 857: FROM MTL_ITEM_REVISIONS_B r

853: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
854: )
855: , NVL( eiuai.REVISION,
856: ( SELECT r.REVISION
857: FROM MTL_ITEM_REVISIONS_B r
858: WHERE r.REVISION_ID = eiuai.REVISION_ID
859: )
860: )
861: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 910: FROM MTL_ITEM_REVISIONS_B R

906: FROM MTL_PARAMETERS P
907: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
908: ),
909: ( SELECT ORGANIZATION_ID
910: FROM MTL_ITEM_REVISIONS_B R
911: WHERE R.REVISION_ID = EIUAI.REVISION_ID
912: ),
913: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
914: )

Line 917: FROM MTL_ITEM_REVISIONS_B r

913: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
914: )
915: , NVL( eiuai.REVISION,
916: ( SELECT r.REVISION
917: FROM MTL_ITEM_REVISIONS_B r
918: WHERE r.REVISION_ID = eiuai.REVISION_ID
919: )
920: )
921: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 935: FROM MTL_ITEM_REVISIONS_B R

931: FROM MTL_PARAMETERS P
932: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
933: ),
934: ( SELECT ORGANIZATION_ID
935: FROM MTL_ITEM_REVISIONS_B R
936: WHERE R.REVISION_ID = EIUAI.REVISION_ID
937: ),
938: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
939: )

Line 942: FROM MTL_ITEM_REVISIONS_B r

938: NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
939: )
940: , NVL( eiuai.REVISION,
941: ( SELECT r.REVISION
942: FROM MTL_ITEM_REVISIONS_B r
943: WHERE r.REVISION_ID = eiuai.REVISION_ID
944: )
945: )
946: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 2631: FROM MTL_ITEM_REVISIONS_B r

2627: Debug_Conc_Log( l_proc_log_prefix || 'Is PDH Batch?: ' || l_pdh_batch_flag );
2628:
2629: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
2630: SET REVISION = NVL( ( SELECT r.REVISION
2631: FROM MTL_ITEM_REVISIONS_B r
2632: WHERE r.REVISION_ID = miri.REVISION_ID
2633: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID
2634: )
2635: , REVISION

Line 3865: FROM MTL_ITEM_REVISIONS_B r

3861: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
3862:
3863: UPDATE MTL_ITEM_REVISIONS_INTERFACE miri
3864: SET REVISION = NVL( ( SELECT r.REVISION
3865: FROM MTL_ITEM_REVISIONS_B r
3866: WHERE r.REVISION_ID = miri.REVISION_ID
3867: AND r.ORGANIZATION_ID = miri.ORGANIZATION_ID
3868: )
3869: , REVISION

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

6106: SOURCE_SYSTEM_ID = p_source_system_id AND
6107: SOURCE_SYSTEM_REFERENCE = p_source_system_reference AND
6108: (ORGANIZATION_ID = p_organization_id OR ORGANIZATION_CODE = p_organization_code) AND
6109: REVISION IS NOT NULL AND
6110: Upper(REVISION) NOT IN ( SELECT B.REVISION FROM MTL_ITEM_REVISIONS_B B, MTL_SYSTEM_ITEMS_INTERFACE MSII
6111: WHERE MSII.SOURCE_SYSTEM_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
6112: AND MSII.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
6113: AND (MSII.ORGANIZATION_ID = MIRI.ORGANIZATION_ID
6114: OR MSII.ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)

Line 7642: FROM MTL_ITEM_REVISIONS_B R

7638: AND ITEM_NUMBER IS NULL;
7639:
7640: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7641: SET REVISION = ( SELECT R.REVISION
7642: FROM MTL_ITEM_REVISIONS_B R
7643: WHERE R.REVISION_ID = eiuai.REVISION_ID
7644: )
7645: WHERE DATA_SET_ID = p_batch_id
7646: AND PROCESS_STATUS = p_process_status

Line 8023: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;

8019: l_err_text VARCHAR2(4000);
8020: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
8021: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;
8022: l_item_id NUMBER;
8023: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
8024: l_error BOOLEAN;
8025: l_import_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
8026:
8027: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;

Line 8289: FROM MTL_ITEM_REVISIONS_B MIR

8285: WHEN MSII.CONFIRM_STATUS = 'CN'
8286: THEN 'CREATE'
8287: WHEN (MSII.CONFIRM_STATUS IN ( 'CM', 'CC', G_CONF_XREF_FAKE, G_CONF_MATCH_FAKE )
8288: AND EXISTS (SELECT NULL
8289: FROM MTL_ITEM_REVISIONS_B MIR
8290: WHERE MIR.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
8291: AND MIR.ORGANIZATION_ID = MIRI.ORGANIZATION_ID
8292: AND MIR.REVISION = MIRI.REVISION) )
8293: THEN 'UPDATE'

Line 8684: FROM MTL_ITEM_REVISIONS_B MIR

8680: THEN 'CREATE'
8681: WHEN MIRI.TRANSACTION_TYPE <> 'SYNC'
8682: THEN MIRI.TRANSACTION_TYPE
8683: WHEN EXISTS (SELECT 1
8684: FROM MTL_ITEM_REVISIONS_B MIR
8685: WHERE MIR.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID
8686: AND MIR.ORGANIZATION_ID = MIRI.ORGANIZATION_ID
8687: AND MIR.REVISION = MIRI.REVISION)
8688: THEN 'UPDATE'

Line 8805: FROM MTL_ITEM_REVISIONS_B

8801: AND MSII.ORGANIZATION_ID = l_org_id
8802: )
8803: WHEN '1'
8804: THEN (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC)
8805: FROM MTL_ITEM_REVISIONS_B
8806: WHERE INVENTORY_ITEM_ID = ATTRS.INVENTORY_ITEM_ID
8807: AND ORGANIZATION_ID = ATTRS.ORGANIZATION_ID)
8808: WHEN '2'
8809: THEN (SELECT REVISION

Line 8862: FROM MTL_ITEM_REVISIONS_B

8858: AND MSII.SOURCE_SYSTEM_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
8859: AND MSII.ORGANIZATION_ID = l_org_id)
8860: )
8861: THEN (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC)
8862: FROM MTL_ITEM_REVISIONS_B
8863: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID
8864: AND ORGANIZATION_ID = MIRI.ORGANIZATION_ID)
8865: WHEN (EXISTS (SELECT NULL
8866: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

Line 9112: FROM MTL_ITEM_REVISIONS_B

9108: l_sql := q'#
9109: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
9110: SET (REVISION, TRANSACTION_TYPE) =
9111: (SELECT MAX(REVISION) KEEP (DENSE_RANK FIRST ORDER BY EFFECTIVITY_DATE DESC), 'UPDATE'
9112: FROM MTL_ITEM_REVISIONS_B
9113: WHERE INVENTORY_ITEM_ID = MIRI.INVENTORY_ITEM_ID
9114: AND ORGANIZATION_ID = MIRI.ORGANIZATION_ID)
9115: WHERE MIRI.SET_PROCESS_ID = :p_data_set_id
9116: AND MIRI.PROCESS_FLAG = 1