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 EGO_IMPORT_BATCHES_B

Line 176: FROM EGO_IMPORT_BATCHES_B

172: AND PROCESS_FLAG = 0
173: AND (MSII.SOURCE_SYSTEM_REFERENCE IS NULL
174: OR MSII.SOURCE_SYSTEM_ID <>
175: (SELECT SOURCE_SYSTEM_ID
176: FROM EGO_IMPORT_BATCHES_B
177: WHERE BATCH_ID = MSII.SET_PROCESS_ID
178: )
179: );
180:

Line 193: FROM EGO_IMPORT_BATCHES_B

189: AND PROCESS_FLAG = 0
190: AND ( MIRI.SOURCE_SYSTEM_REFERENCE IS NULL
191: OR MIRI.SOURCE_SYSTEM_ID <>
192: (SELECT SOURCE_SYSTEM_ID
193: FROM EGO_IMPORT_BATCHES_B
194: WHERE BATCH_ID = MIRI.SET_PROCESS_ID
195: )
196: );
197:

Line 210: FROM EGO_IMPORT_BATCHES_B

206: AND PROCESS_FLAG = 0
207: AND (MICI.SOURCE_SYSTEM_REFERENCE IS NULL
208: OR MICI.SOURCE_SYSTEM_ID <>
209: (SELECT SOURCE_SYSTEM_ID
210: FROM EGO_IMPORT_BATCHES_B
211: WHERE BATCH_ID = MICI.SET_PROCESS_ID
212: )
213: );
214:

Line 227: FROM EGO_IMPORT_BATCHES_B

223: AND PROCESS_STATUS = 0
224: AND (EIUAI.SOURCE_SYSTEM_REFERENCE IS NULL
225: OR EIUAI.SOURCE_SYSTEM_ID <>
226: (SELECT SOURCE_SYSTEM_ID
227: FROM EGO_IMPORT_BATCHES_B
228: WHERE BATCH_ID = EIUAI.DATA_SET_ID
229: )
230: );
231:

Line 244: FROM EGO_IMPORT_BATCHES_B

240: AND PROCESS_STATUS = 0
241: AND (EIPI.SOURCE_SYSTEM_REFERENCE IS NULL
242: OR EIPI.SOURCE_SYSTEM_ID <>
243: (SELECT SOURCE_SYSTEM_ID
244: FROM EGO_IMPORT_BATCHES_B
245: WHERE BATCH_ID = EIPI.DATA_SET_ID
246: )
247: );
248:

Line 261: FROM EGO_IMPORT_BATCHES_B

257: AND PROCESS_FLAG = 0
258: AND (EAI.SOURCE_SYSTEM_REFERENCE IS NULL
259: OR EAI.SOURCE_SYSTEM_ID <>
260: (SELECT SOURCE_SYSTEM_ID
261: FROM EGO_IMPORT_BATCHES_B
262: WHERE BATCH_ID = EAI.DATA_SET_ID
263: )
264: );
265:

Line 278: FROM EGO_IMPORT_BATCHES_B

274: AND PROCESS_FLAG = 0
275: AND (EIAI.SOURCE_SYSTEM_REFERENCE IS NULL
276: OR EIAI.SOURCE_SYSTEM_ID <>
277: (SELECT SOURCE_SYSTEM_ID
278: FROM EGO_IMPORT_BATCHES_B
279: WHERE BATCH_ID = EIAI.BATCH_ID
280: )
281: );
282: -- R12C:END ASSOCSINTF

Line 768: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE := NULL;

764: , x_ss_id OUT NOCOPY NUMBER
765: )
766: IS
767: l_org_id NUMBER := NULL;
768: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE := NULL;
769: BEGIN
770: Debug_Conc_Log( 'Attempting to resolve merge parameters from batch header for batch_id='
771: || to_char( p_batch_id ) );
772: BEGIN

Line 778: , EGO_IMPORT_BATCHES_B ba

774: BA.SOURCE_SYSTEM_ID
775: INTO l_org_id
776: , l_ss_id
777: FROM MTL_PARAMETERS MP
778: , EGO_IMPORT_BATCHES_B ba
779: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
780: AND BA.BATCH_ID = p_batch_id;
781: EXCEPTION
782: WHEN NO_DATA_FOUND THEN

Line 5756: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt

5752: Debug_Conc_Log('Starting Process_SSXref_Intf_Rows for batch_id='||TO_CHAR(p_data_set_id));
5753: BEGIN
5754: SELECT b.SOURCE_SYSTEM_ID, NVL(opt.IMPORT_XREF_ONLY, 'N')
5755: INTO l_ss_id, l_import_xref_only
5756: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt
5757: WHERE b.BATCH_ID = p_data_set_id
5758: AND b.BATCH_ID = opt.BATCH_ID;
5759: EXCEPTION WHEN NO_DATA_FOUND THEN
5760: l_ss_id := get_pdh_source_system_id;

Line 6025: EGO_IMPORT_BATCHES_B BA

6021: MP.ORGANIZATION_ID,
6022: MP.ORGANIZATION_CODE
6023: INTO l_org_id, l_org_code
6024: FROM MTL_PARAMETERS MP,
6025: EGO_IMPORT_BATCHES_B BA
6026: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6027: BA.BATCH_ID = p_data_set_id;
6028:
6029: -- Set the confirm status and item number based on the parameters

Line 6211: EGO_IMPORT_BATCHES_B ba,

6207: MP.ORGANIZATION_CODE,
6208: NVL(OPT.REVISION_IMPORT_POLICY, 'L')
6209: INTO l_organization_id, l_organization_code, l_batch_rev_policy
6210: FROM MTL_PARAMETERS MP,
6211: EGO_IMPORT_BATCHES_B ba,
6212: EGO_IMPORT_OPTION_SETS OPT
6213: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6214: BA.BATCH_ID = OPT.BATCH_ID AND
6215: BA.BATCH_ID = p_data_set_id;

Line 6236: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, EGO_IMPORT_BATCHES_B BATCH

6232: CONFIRM_STATUS,
6233: NVL(REVISION_IMPORT_POLICY, l_batch_rev_policy),
6234: MSII.STYLE_ITEM_FLAG
6235: INTO l_pdh_item_number, l_pdh_description, l_pdh_item_catalog_group_id, l_confirm_status, l_instance_rev_policy, l_style_item_flag
6236: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, EGO_IMPORT_BATCHES_B BATCH
6237: WHERE MSII.SET_PROCESS_ID = p_data_set_id AND
6238: MSII.SOURCE_SYSTEM_ID = p_source_system_id AND
6239: MSII.SOURCE_SYSTEM_REFERENCE = p_source_system_reference AND
6240: MSII.ORGANIZATION_ID = BATCH.ORGANIZATION_ID AND

Line 6494: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;

6490: )
6491: IS
6492: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6493: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6494: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6495: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6496: l_party_name VARCHAR2(1000);
6497: l_security_predicate VARCHAR2(4000);
6498: l_return_status VARCHAR2(100);

Line 6522: EGO_IMPORT_BATCHES_B BA,

6518: NVL(OPT.IMPORT_XREF_ONLY, 'N'),
6519: NVL(ENABLED_FOR_DATA_POOL, 'N')
6520: INTO l_org_id, l_org_code, l_ss_id, l_import_xref_only, l_enabled_for_data_pool
6521: FROM MTL_PARAMETERS MP,
6522: EGO_IMPORT_BATCHES_B BA,
6523: EGO_IMPORT_OPTION_SETS OPT
6524: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
6525: AND BA.BATCH_ID = p_data_set_id
6526: AND BA.BATCH_ID = OPT.BATCH_ID;

Line 7623: FROM EGO_IMPORT_BATCHES_B

7619: BEGIN
7620: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Starting');
7621: BEGIN
7622: SELECT SOURCE_SYSTEM_ID INTO l_ss_id
7623: FROM EGO_IMPORT_BATCHES_B
7624: WHERE BATCH_ID = p_batch_id;
7625: EXCEPTION WHEN NO_DATA_FOUND THEN
7626: l_ss_id := GET_PDH_SOURCE_SYSTEM_ID();
7627: END;

Line 8020: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;

8016: l_prog_appid NUMBER := FND_GLOBAL.PROG_APPL_ID;
8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
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;

Line 8021: l_org_id EGO_IMPORT_BATCHES_B.ORGANIZATION_ID%TYPE;

8017: l_prog_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
8018: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
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;

Line 8045: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT

8041: NVL(OPT.REVISION_IMPORT_POLICY, 'L'),
8042: NVL(opt.IMPORT_XREF_ONLY, 'N'),
8043: NVL(opt.ENABLED_FOR_DATA_POOL, 'N')
8044: INTO l_ss_id, l_org_id, l_import_policy, l_import_xref_only, l_enabled_for_data_pool
8045: FROM EGO_IMPORT_BATCHES_B BA, EGO_IMPORT_OPTION_SETS OPT
8046: WHERE BA.BATCH_ID = p_data_set_id AND BA.BATCH_ID = OPT.BATCH_ID;
8047: EXCEPTION WHEN NO_DATA_FOUND THEN
8048: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
8049: BEGIN

Line 9521: l_batch_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;

9517: l_process_flag MTL_SYSTEM_ITEMS_INTERFACE.PROCESS_FLAG%TYPE;
9518: l_ssr MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE;
9519: l_ss_id MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE;
9520: l_ssr_desc MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE_DESC%TYPE;
9521: l_batch_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_ID%TYPE;
9522: l_request_id MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE;
9523: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
9524: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
9525: l_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;

Line 9548: FROM EGO_IMPORT_BATCHES_B BATCH, EGO_IMPORT_OPTION_SETS OPT

9544: , NVL( OPT.IMPORT_XREF_ONLY, 'N' )
9545: INTO l_batch_ss_id
9546: , l_org_id
9547: , l_ssxref_only
9548: FROM EGO_IMPORT_BATCHES_B BATCH, EGO_IMPORT_OPTION_SETS OPT
9549: WHERE BATCH.BATCH_ID = p_batch_id
9550: AND BATCH.ORGANIZATION_ID = p_organization_id
9551: AND BATCH.BATCH_ID = OPT.BATCH_ID;
9552: EXCEPTION

Line 10122: EGO_IMPORT_BATCHES_B impbat,

10118: END
10119: ) BATCH_STATUS
10120: INTO l_batch_status
10121: FROM
10122: EGO_IMPORT_BATCHES_B impbat,
10123: FND_CONCURRENT_REQUESTS crimp,
10124: FND_CONCURRENT_REQUESTS crmatch
10125: WHERE impbat.BATCH_ID = p_batch_id
10126: AND impbat.LAST_MATCH_REQUEST_ID = crmatch.REQUEST_ID (+)

Line 12306: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, EGO_IMPORT_BATCHES_B BA

12302: ,retcode OUT NOCOPY VARCHAR2
12303: ) IS
12304: CURSOR cur_old_status IS
12305: SELECT CONFIRM_STATUS
12306: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII, EGO_IMPORT_BATCHES_B BA
12307: WHERE MSII.SET_PROCESS_ID = p_batch_id
12308: AND MSII.SOURCE_SYSTEM_ID = p_source_system_id
12309: AND MSII.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
12310: AND MSII.ORGANIZATION_ID = BA.ORGANIZATION_ID

Line 12420: AND ORGANIZATION_ID = (SELECT ORGANIZATION_id FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID = p_batch_id)

12416: SET CONFIRM_STATUS = l_resolved_status, INVENTORY_ITEM_ID = p_inventory_item_id
12417: WHERE SET_PROCESS_ID = p_batch_id
12418: AND SOURCE_SYSTEM_ID = p_source_system_id
12419: AND SOURCE_SYSTEM_REFERENCE = p_source_system_reference
12420: AND ORGANIZATION_ID = (SELECT ORGANIZATION_id FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID = p_batch_id)
12421: AND NVL(PROCESS_FLAG, 0) < 1;
12422:
12423: IF l_old_status = G_EXCLUDED THEN
12424: DELETE FROM EGO_IMPORT_EXCLUDED_SS_ITEMS

Line 12922: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt

12918:
12919: -- Bug: 5262421, if IMPORT_XREF_ONLY is 'Y', then we will show 0 as after import count for AML
12920: BEGIN
12921: SELECT NVL(opt.IMPORT_XREF_ONLY, 'N') INTO l_import_xref_only
12922: FROM EGO_IMPORT_BATCHES_B b, EGO_IMPORT_OPTION_SETS opt
12923: WHERE b.BATCH_ID = p_set_process_id
12924: AND b.BATCH_ID = opt.BATCH_ID;
12925: EXCEPTION WHEN NO_DATA_FOUND THEN
12926: l_import_xref_only := 'N';

Line 13130: * This method updates the request_ids to ego_import_batches_b table.

13126: RETURN l_return_table;
13127: END GET_IMPORT_DETAILS_DATA;
13128:
13129: /*
13130: * This method updates the request_ids to ego_import_batches_b table.
13131: */
13132: PROCEDURE Update_Request_Id_To_Batch (
13133: p_import_request_id IN NUMBER,
13134: p_match_request_id IN NUMBER,

Line 13139: UPDATE EGO_IMPORT_BATCHES_B

13135: p_batch_id IN NUMBER)
13136: IS
13137: BEGIN
13138: IF ( NVL(p_import_request_id, 0) > 0 ) OR ( NVL(p_match_request_id, 0) > 0 ) THEN
13139: UPDATE EGO_IMPORT_BATCHES_B
13140: SET LAST_MATCH_REQUEST_ID = DECODE(p_match_request_id, NULL, LAST_MATCH_REQUEST_ID, 0, LAST_MATCH_REQUEST_ID, p_match_request_id),
13141: LAST_IMPORT_REQUEST_ID = DECODE(p_import_request_id, NULL, LAST_IMPORT_REQUEST_ID, 0, LAST_IMPORT_REQUEST_ID, p_import_request_id)
13142: WHERE BATCH_ID = p_batch_id;
13143: END IF; -- IF ( NVL(p_import_request_id, 0) > 0 ) OR ( NVL(p_match_request_id, 0) > 0 ) THEN