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.CTO_UPDATE_ITEMS_PK dependencies on BOM_CTO_SRC_ORGS

Line 141: bom_cto_src_orgs bcso

137: bcso.create_src_rules,
138: bcso.model_item_id,
139: bcso.config_item_id
140: from bom_cto_order_lines_upg bcolu,
141: bom_cto_src_orgs bcso
142: where bcolu.ato_line_id = p_ato_line_id
143: and bcolu.bom_item_type = '1'
144: and nvl(bcolu.wip_supply_type, 1) <> 6
145: and bcolu.option_specific = 'N'

Line 290: delete from bom_cto_src_orgs_b

286:
287: --
288: -- Delete from bcso_b
289: --
290: delete from bom_cto_src_orgs_b
291: where line_id in
292: (select /* INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 BOM_CTO_ORDER_LINES_UPG_N2 ) */
293: line_id
294: from bom_cto_order_lines_upg

Line 895: bom_cto_src_orgs_b bcso

891: bcso.line_id,
892: bcso.top_model_line_id,
893: bcso.config_item_id
894: from bom_cto_model_orgs bcmo,
895: bom_cto_src_orgs_b bcso
896: where bcso.config_item_id = bcmo.config_item_id and
897: bcso.config_item_id in (select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 ) */
898: distinct config_item_id
899: from bom_cto_order_lines_upg

Line 943: DELETE from bom_cto_src_orgs_b

939:
940: lStmtNum := 20;
941: WriteToLog('Fecthed records from c_line_info count is :'||line_id_rec_tab.count, 3);
942:
943: DELETE from bom_cto_src_orgs_b
944: where (line_id) IN (select distinct bcso.line_id
945: from bom_cto_src_orgs_b bcso
946: where bcso.config_item_id in (select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 ) */
947: distinct config_item_id

Line 945: from bom_cto_src_orgs_b bcso

941: WriteToLog('Fecthed records from c_line_info count is :'||line_id_rec_tab.count, 3);
942:
943: DELETE from bom_cto_src_orgs_b
944: where (line_id) IN (select distinct bcso.line_id
945: from bom_cto_src_orgs_b bcso
946: where bcso.config_item_id in (select /*+ INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 ) */
947: distinct config_item_id
948: from bom_cto_order_lines_upg
949: where ato_line_id = p_ato_line_id

Line 955: WriteToLog('Deleted data from bom_cto_src_orgs_b count is :'||sql%rowcount, 3);

951: and config_item_id is not null
952: and status = 'UPG'
953: and nvl(perform_match, 'N') IN ('Y','U')));
954:
955: WriteToLog('Deleted data from bom_cto_src_orgs_b count is :'||sql%rowcount, 3);
956:
957:
958: lStmtNum := 30;
959: FORALL cntr in 1..line_id_rec_tab.COUNT

Line 960: insert into bom_cto_src_orgs_b

956:
957:
958: lStmtNum := 30;
959: FORALL cntr in 1..line_id_rec_tab.COUNT
960: insert into bom_cto_src_orgs_b
961: (
962: top_model_line_id,
963: line_id,
964: group_reference_id,

Line 1005: WriteToLog('After insert into bom_cto_src_orgs_b count is :'||sql%rowcount, 3);

1001: null, -- program_application_id
1002: null, -- program_id
1003: sysdate); -- program_update_date
1004:
1005: WriteToLog('After insert into bom_cto_src_orgs_b count is :'||sql%rowcount, 3);
1006:
1007: lStmtNum := 40;
1008: update /* INDEX ( BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_U1 ) */
1009: bom_cto_order_lines_upg

Line 1012: from bom_cto_src_orgs_b

1008: update /* INDEX ( BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_U1 ) */
1009: bom_cto_order_lines_upg
1010: set status = 'BCSO'
1011: where line_id in ( select distinct line_id
1012: from bom_cto_src_orgs_b
1013: where config_item_id in( select /*+INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 ) */
1014: distinct config_item_id
1015: from bom_cto_order_lines_upg
1016: where ato_line_id = p_ato_line_id

Line 1065: bom_cto_src_orgs bcso,

1061: DECODE(bcso.ORGANIZATION_ID, bcolu.ship_from_org_id, get_cost_group(bcolu.ship_from_org_id, bcolu.line_id), 1) cost_group_id,
1062: bcolu.config_item_id config_item_id
1063: from
1064: cst_item_costs c,
1065: bom_cto_src_orgs bcso,
1066: bom_cto_order_lines_upg bcolu,
1067: mtl_parameters mp1
1068: where bcolu.config_item_id is not null
1069: and bcolu.status = 'BCSO'

Line 1182: bom_cto_src_orgs bcso,

1178: gUserId, --created_by
1179: gLoginId --last_update_login
1180: from
1181: mtl_system_items_tl m,
1182: bom_cto_src_orgs bcso,
1183: bom_cto_order_lines_upg bcolu,
1184: fnd_languages l
1185: where bcolu.config_item_id is not null
1186: and bcolu.status = 'BCSO'

Line 1235: bom_cto_src_orgs bcso,

1231: null,
1232: sysdate,
1233: null -- req_id
1234: from mtl_system_items m,
1235: bom_cto_src_orgs bcso,
1236: bom_cto_order_lines_upg bcolu
1237: where bcolu.config_item_id is not null
1238: and bcolu.status = 'BCSO'
1239: and m.inventory_item_id = bcolu.inventory_item_id

Line 1340: bom_cto_src_orgs bcso,

1336: gUserId, --created_by
1337: gLoginId --last_update_login
1338: from
1339: mtl_system_items_tl m,
1340: bom_cto_src_orgs bcso,
1341: fnd_languages l,
1342: mtl_item_revisions_b mr --3338108
1343: where m.inventory_item_id = v_bcolu_cfg.inventory_item_id
1344: and bcso.model_item_id = m.inventory_item_id

Line 1420: bom_cto_src_orgs bcso,

1416: bcolu.inventory_item_id,
1417: MP2.cost_organization_id
1418: from mtl_parameters mp2,
1419: mtl_parameters mp3,
1420: bom_cto_src_orgs bcso,
1421: bom_cto_order_lines_upg bcolu
1422: where bcolu.config_item_id is not null
1423: and bcolu.status = 'BCSO'
1424: and bcso.model_item_id = bcolu.inventory_item_id

Line 1593: bom_cto_src_orgs bcso,

1589: from
1590: mtl_parameters MP1,
1591: cst_item_costs C,
1592: mtl_system_items S,
1593: bom_cto_src_orgs bcso,
1594: bom_cto_order_lines_upg bcolu
1595: where bcolu.config_item_id is not null
1596: and bcolu.status = 'BCSO'
1597: and S.organization_id = C.organization_id

Line 1816: bom_cto_src_orgs bcso,

1812: from
1813: mtl_parameters MP1,
1814: cst_item_costs C,
1815: mtl_system_items S,
1816: bom_cto_src_orgs bcso,
1817: bom_cto_order_lines_upg bcolu
1818: where bcolu.config_item_id is not null
1819: and bcolu.status = 'BCSO'
1820: and S.organization_id = C.organization_id

Line 1979: bom_cto_src_orgs bcso,

1975: from
1976: mtl_parameters MP1,
1977: cst_item_cost_details C,
1978: mtl_system_items S,
1979: bom_cto_src_orgs bcso,
1980: bom_cto_order_lines_upg bcolu
1981: where bcolu.config_item_id is not null
1982: and bcolu.status = 'BCSO'
1983: and S.organization_id = C.organization_id

Line 2101: bom_cto_src_orgs bcso,

2097: from
2098: mtl_parameters MP1,
2099: cst_item_cost_details C,
2100: mtl_system_items S,
2101: bom_cto_src_orgs bcso,
2102: bom_cto_order_lines_upg bcolu
2103: where bcolu.config_item_id is not null
2104: and bcolu.status = 'BCSO'
2105: and S.organization_id = C.organization_id

Line 2273: bom_cto_src_orgs bcso,

2269: SYSDATE, -- program_update_date
2270: ic.organization_id
2271: from
2272: mtl_item_categories ic,
2273: bom_cto_src_orgs bcso,
2274: bom_cto_order_lines_upg bcolu
2275: where bcolu.config_item_id is not null
2276: and bcolu.status = 'BCSO'
2277: and ic.inventory_item_id = bcolu.inventory_item_id

Line 2333: bom_cto_src_orgs bcso,

2329: from
2330: mtl_item_categories ic,
2331: mtl_category_sets_b mcsb,
2332: mtl_default_category_sets mdcs,
2333: bom_cto_src_orgs bcso,
2334: bom_cto_order_lines_upg bcolu
2335: where bcolu.config_item_id is not null
2336: and bcolu.status = 'BCSO'
2337: and bcolu.inventory_item_id = ic.inventory_item_id

Line 2398: bom_cto_src_orgs bcso,

2394: SYSDATE, -- program_update_date
2395: ic.organization_id
2396: from
2397: mtl_item_categories ic,
2398: bom_cto_src_orgs bcso,
2399: bom_cto_order_lines_upg bcolu
2400: where bcolu.config_item_id is not null
2401: and bcolu.status = 'BCSO'
2402: and ic.inventory_item_id = bcolu.inventory_item_id

Line 2459: bom_cto_src_orgs bcso,

2455: from
2456: mtl_item_categories ic,
2457: mtl_category_sets_b mcsb,
2458: mtl_default_category_sets mdcs,
2459: bom_cto_src_orgs bcso,
2460: bom_cto_order_lines_upg bcolu
2461: where bcolu.config_item_id is not null
2462: and bcolu.status = 'BCSO'
2463: and bcolu.inventory_item_id = ic.inventory_item_id

Line 2524: bom_cto_src_orgs bcso,

2520: NULL, -- program_id
2521: SYSDATE, -- program_update_date
2522: ri.organization_id
2523: from mtl_related_items ri,
2524: bom_cto_src_orgs bcso,
2525: bom_cto_order_lines_upg bcolu
2526: where bcolu.config_item_id is not null
2527: and bcolu.status = 'BCSO'
2528: and ri.inventory_item_id = bcolu.inventory_item_id

Line 2633: bom_cto_src_orgs bcso,

2629: SYSDATE, -- program_update_date
2630: isi.ENCUMBRANCE_ACCOUNT
2631: from
2632: mtl_item_sub_inventories isi,
2633: bom_cto_src_orgs bcso,
2634: bom_cto_order_lines_upg bcolu
2635: where bcolu.config_item_id is not null
2636: and bcolu.status = 'BCSO'
2637: and isi.organization_id = bcso.organization_id

Line 2693: bom_cto_src_orgs bcso,

2689: NULL, -- program_id
2690: SYSDATE -- program_update_date
2691: from
2692: mtl_secondary_locators sl,
2693: bom_cto_src_orgs bcso,
2694: bom_cto_order_lines_upg bcolu
2695: where bcolu.config_item_id is not null
2696: and bcolu.status = 'BCSO'
2697: and sl.organization_id = bcso.organization_id

Line 2731: bom_cto_src_orgs bcso,

2727: t_cross_ref,
2728: t_org_independent_flag
2729: from
2730: mtl_cross_references_b cr_b,
2731: bom_cto_src_orgs bcso,
2732: bom_cto_order_lines_upg bcolu
2733: where bcolu.config_item_id is not null
2734: and bcolu.status = 'BCSO'
2735: and (cr_b.organization_id = bcso.organization_id or

Line 2914: bom_cto_src_orgs bcso,

2910: NULL, -- program_id
2911: SYSDATE -- program_update_date
2912: from
2913: mtl_item_sub_defaults sd,
2914: bom_cto_src_orgs bcso,
2915: bom_cto_order_lines_upg bcolu
2916: where bcolu.config_item_id is not null
2917: and bcolu.status = 'BCSO'
2918: and sd.organization_id = bcso.organization_id

Line 2971: bom_cto_src_orgs bcso,

2967: NULL, -- program_id
2968: SYSDATE -- program_update_date
2969: from
2970: mtl_item_loc_defaults ld,
2971: bom_cto_src_orgs bcso,
2972: bom_cto_order_lines_upg bcolu
2973: where bcolu.config_item_id is not null
2974: and bcolu.status = 'BCSO'
2975: and ld.organization_id = bcso.organization_id

Line 3809: bom_cto_src_orgs bcso,

3805: from
3806: mtl_parameters mp1,
3807: mtl_system_items_b m, -- model
3808: mtl_system_items_b c, -- config
3809: bom_cto_src_orgs bcso,
3810: bom_cto_order_lines_upg bcolu
3811: where bcolu.config_item_id is not null
3812: and bcolu.status = 'BCSO'
3813: and m.inventory_item_id = bcolu.inventory_item_id

Line 4593: bom_cto_src_orgs bcso,

4589:
4590: from
4591: mtl_system_items_b m, -- model
4592: mtl_system_items_b config, -- config
4593: bom_cto_src_orgs bcso,
4594: bom_cto_order_lines_upg bcolu
4595: where bcolu.config_item_id is not null
4596: and bcolu.status = 'BCSO'
4597: and m.inventory_item_id = bcolu.inventory_item_id