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_B

Line 139: bom_cto_src_orgs bcso

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

Line 268: delete from bom_cto_src_orgs_b

264:
265: --
266: -- Delete from bcso_b
267: --
268: delete from bom_cto_src_orgs_b
269: where line_id in
270: (select /* INDEX (BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N4 BOM_CTO_ORDER_LINES_UPG_N2 ) */
271: line_id
272: from bom_cto_order_lines_upg

Line 753: from bom_cto_src_orgs_b

749: and status = 'UPG';
750:
751: CURSOR c_lines(p_config_item_id number) IS
752: select distinct line_id, top_model_line_id
753: from bom_cto_src_orgs_b
754: where config_item_id = p_config_item_id;
755:
756: lStmtNum number;
757: v_group_reference_id number;

Line 801: delete from bom_cto_src_orgs_b

797: FOR v_lines IN c_lines(v_configs.config_item_id) LOOP
798:
799: WriteToLog('Processing line_id::'||v_lines.line_id, 4);
800: lStmtNum := 40;
801: delete from bom_cto_src_orgs_b
802: where line_id = v_lines.line_id;
803:
804: WriteToLog('Deleted rows from bcso_b::'||sql%rowcount, 4);
805: lStmtNum := 50;

Line 806: insert into bom_cto_src_orgs_b

802: where line_id = v_lines.line_id;
803:
804: WriteToLog('Deleted rows from bcso_b::'||sql%rowcount, 4);
805: lStmtNum := 50;
806: insert into bom_cto_src_orgs_b
807: (
808: top_model_line_id,
809: line_id,
810: group_reference_id,

Line 853: from bom_cto_src_orgs_b

849: sysdate -- program_update_date
850: from dual
851: where NOT EXISTS
852: (select NULL
853: from bom_cto_src_orgs_b
854: where line_id = v_lines.line_id );
855:
856: WriteToLog('Inserted rows into bcso_b::'||sql%rowcount, 4);
857: END LOOP;

Line 877: from bom_cto_src_orgs_b

873: bom_cto_order_lines_upg
874: set status = 'BCSO'
875: where line_id in (
876: select distinct line_id
877: from bom_cto_src_orgs_b
878: where config_item_id = v_configs.config_item_id);
879:
880: WriteToLog('Updated rows to status BCSO::'||sql%rowcount, 4);
881:

Line 922: bom_cto_src_orgs bcso,

918: DECODE(bcso.ORGANIZATION_ID, bcolu.ship_from_org_id, get_cost_group(bcolu.ship_from_org_id, bcolu.line_id), 1) cost_group_id,
919: bcolu.config_item_id config_item_id
920: from
921: cst_item_costs c,
922: bom_cto_src_orgs bcso,
923: bom_cto_order_lines_upg bcolu,
924: mtl_parameters mp1
925: where bcolu.config_item_id is not null
926: and bcolu.status = 'BCSO'

Line 1039: bom_cto_src_orgs bcso,

1035: gUserId, --created_by
1036: gLoginId --last_update_login
1037: from
1038: mtl_system_items_tl m,
1039: bom_cto_src_orgs bcso,
1040: bom_cto_order_lines_upg bcolu,
1041: fnd_languages l
1042: where bcolu.config_item_id is not null
1043: and bcolu.status = 'BCSO'

Line 1092: bom_cto_src_orgs bcso,

1088: null,
1089: sysdate,
1090: null -- req_id
1091: from mtl_system_items m,
1092: bom_cto_src_orgs bcso,
1093: bom_cto_order_lines_upg bcolu
1094: where bcolu.config_item_id is not null
1095: and bcolu.status = 'BCSO'
1096: and m.inventory_item_id = bcolu.inventory_item_id

Line 1197: bom_cto_src_orgs bcso,

1193: gUserId, --created_by
1194: gLoginId --last_update_login
1195: from
1196: mtl_system_items_tl m,
1197: bom_cto_src_orgs bcso,
1198: fnd_languages l,
1199: mtl_item_revisions_b mr --3338108
1200: where m.inventory_item_id = v_bcolu_cfg.inventory_item_id
1201: and bcso.model_item_id = m.inventory_item_id

Line 1277: bom_cto_src_orgs bcso,

1273: bcolu.inventory_item_id,
1274: MP2.cost_organization_id
1275: from mtl_parameters mp2,
1276: mtl_parameters mp3,
1277: bom_cto_src_orgs bcso,
1278: bom_cto_order_lines_upg bcolu
1279: where bcolu.config_item_id is not null
1280: and bcolu.status = 'BCSO'
1281: and bcso.model_item_id = bcolu.inventory_item_id

Line 1450: bom_cto_src_orgs bcso,

1446: from
1447: mtl_parameters MP1,
1448: cst_item_costs C,
1449: mtl_system_items S,
1450: bom_cto_src_orgs bcso,
1451: bom_cto_order_lines_upg bcolu
1452: where bcolu.config_item_id is not null
1453: and bcolu.status = 'BCSO'
1454: and S.organization_id = C.organization_id

Line 1673: bom_cto_src_orgs bcso,

1669: from
1670: mtl_parameters MP1,
1671: cst_item_costs C,
1672: mtl_system_items S,
1673: bom_cto_src_orgs bcso,
1674: bom_cto_order_lines_upg bcolu
1675: where bcolu.config_item_id is not null
1676: and bcolu.status = 'BCSO'
1677: and S.organization_id = C.organization_id

Line 2126: bom_cto_src_orgs bcso,

2122: SYSDATE, -- program_update_date
2123: ic.organization_id
2124: from
2125: mtl_item_categories ic,
2126: bom_cto_src_orgs bcso,
2127: bom_cto_order_lines_upg bcolu
2128: where bcolu.config_item_id is not null
2129: and bcolu.status = 'BCSO'
2130: and ic.inventory_item_id = bcolu.inventory_item_id

Line 2237: bom_cto_src_orgs bcso,

2233: SYSDATE, -- program_update_date
2234: ic.organization_id
2235: from
2236: mtl_item_categories ic,
2237: bom_cto_src_orgs bcso,
2238: bom_cto_order_lines_upg bcolu
2239: where bcolu.config_item_id is not null
2240: and bcolu.status = 'BCSO'
2241: and ic.inventory_item_id = bcolu.inventory_item_id

Line 2355: bom_cto_src_orgs bcso,

2351: NULL, -- program_id
2352: SYSDATE, -- program_update_date
2353: ri.organization_id
2354: from mtl_related_items ri,
2355: bom_cto_src_orgs bcso,
2356: bom_cto_order_lines_upg bcolu
2357: where bcolu.config_item_id is not null
2358: and bcolu.status = 'BCSO'
2359: and ri.inventory_item_id = bcolu.inventory_item_id

Line 2464: bom_cto_src_orgs bcso,

2460: SYSDATE, -- program_update_date
2461: isi.ENCUMBRANCE_ACCOUNT
2462: from
2463: mtl_item_sub_inventories isi,
2464: bom_cto_src_orgs bcso,
2465: bom_cto_order_lines_upg bcolu
2466: where bcolu.config_item_id is not null
2467: and bcolu.status = 'BCSO'
2468: and isi.organization_id = bcso.organization_id

Line 2524: bom_cto_src_orgs bcso,

2520: NULL, -- program_id
2521: SYSDATE -- program_update_date
2522: from
2523: mtl_secondary_locators sl,
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 sl.organization_id = bcso.organization_id

Line 2562: bom_cto_src_orgs bcso,

2558: t_cross_ref,
2559: t_org_independent_flag
2560: from
2561: mtl_cross_references_b cr_b,
2562: bom_cto_src_orgs bcso,
2563: bom_cto_order_lines_upg bcolu
2564: where bcolu.config_item_id is not null
2565: and bcolu.status = 'BCSO'
2566: and (cr_b.organization_id = bcso.organization_id or

Line 2745: bom_cto_src_orgs bcso,

2741: NULL, -- program_id
2742: SYSDATE -- program_update_date
2743: from
2744: mtl_item_sub_defaults sd,
2745: bom_cto_src_orgs bcso,
2746: bom_cto_order_lines_upg bcolu
2747: where bcolu.config_item_id is not null
2748: and bcolu.status = 'BCSO'
2749: and sd.organization_id = bcso.organization_id

Line 3597: bom_cto_src_orgs bcso,

3593: from
3594: mtl_parameters mp1,
3595: mtl_system_items_b m, -- model
3596: mtl_system_items_b c, -- config
3597: bom_cto_src_orgs bcso,
3598: bom_cto_order_lines_upg bcolu
3599: where bcolu.config_item_id is not null
3600: and bcolu.status = 'BCSO'
3601: and m.inventory_item_id = bcolu.inventory_item_id

Line 4341: bom_cto_src_orgs bcso,

4337:
4338: from
4339: mtl_system_items_b m, -- model
4340: mtl_system_items_b config, -- config
4341: bom_cto_src_orgs bcso,
4342: bom_cto_order_lines_upg bcolu
4343: where bcolu.config_item_id is not null
4344: and bcolu.status = 'BCSO'
4345: and m.inventory_item_id = bcolu.inventory_item_id