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_CONFIG_ITEM_PK dependencies on BOM_CTO_SRC_ORGS

Line 1578: -- deleting from bom_cto_order_lines and bom_cto_src_orgs

1574:
1575:
1576:
1577: --
1578: -- deleting from bom_cto_order_lines and bom_cto_src_orgs
1579: -- for this top ato line id
1580: --
1581:
1582: lStmtNumber := 550;

Line 5381: bom_cto_src_orgs bcso,

5377: 2
5378:
5379: from
5380: mtl_system_items_b m, -- Model
5381: bom_cto_src_orgs bcso,
5382: bom_cto_order_lines bcol
5383: where m.inventory_item_id = pModelId
5384: and bcso.model_item_id = pModelId
5385: and bcso.line_id = pLineId

Line 5741: bom_cto_src_orgs bcso,

5737: */
5738: from
5739: -- bugfix 2457514 mtl_system_items_b m, -- Model
5740: mtl_system_items_tl m, -- 2457514
5741: bom_cto_src_orgs bcso,
5742: fnd_languages l
5743: where
5744: --m.inventory_item_id = pModelId -- bugfix 12809414
5745: m.inventory_item_id = bcso.model_item_id

Line 5833: -- update bom_cto_src_orgs with new config item

5829:
5830:
5831:
5832: --
5833: -- update bom_cto_src_orgs with new config item
5834: --
5835:
5836: lStmtNumber := 130;
5837: lStatus := CTO_UTILITY_PK.Update_Src_Orgs(

Line 6234: bom_cto_src_orgs bcso

6230: */
6231: from mtl_parameters mp1,
6232: mtl_parameters mp2,
6233: cst_item_costs c,
6234: bom_cto_src_orgs bcso
6235: where c.organization_id = mp1.organization_id
6236: and c.inventory_item_id = pModelId
6237: and C.COST_TYPE_ID = 2 -- Average Costing
6238: and bcso.model_item_id = pModelId

Line 6406: bom_cto_src_orgs bcso

6402: null,
6403: sysdate,
6404: null -- req_id
6405: from mtl_system_items m,
6406: bom_cto_src_orgs bcso
6407: where m.inventory_item_id = pModelId
6408: and bcso.model_item_id = pModelId
6409: and bcso.line_id = pLineId
6410: and m.organization_id = bcso.organization_id

Line 6471: bom_cto_src_orgs bcso,

6467: sysdate,
6468: sysdate
6469: from
6470: mtl_system_items m,
6471: bom_cto_src_orgs bcso,
6472: mtl_parameters mp1
6473: where m.inventory_item_id = pModelId
6474: and bcso.model_item_id = pModelId
6475: and bcso.line_id = pLineId

Line 6575: from mtl_parameters mp2, mtl_parameters mp3, bom_cto_src_orgs bcso

6571: and C.cost_type_id = CICD.cost_type_id(+)
6572: and CICD.rollup_source_type(+) = 1 -- User Defined
6573: --4172300
6574: and MP1.organization_id in ( select distinct MP2.cost_organization_id
6575: from mtl_parameters mp2, mtl_parameters mp3, bom_cto_src_orgs bcso
6576: where bcso.model_item_id = pModelId
6577: and bcso.line_id = pLineId
6578: and MP3.organization_id = bcso.organization_id
6579: and ((mp2.organization_id = bcso.organization_id) OR

Line 6742: bom_cto_src_orgs bcso

6738: from
6739: mtl_parameters MP1,
6740: cst_item_costs C,
6741: mtl_system_items S,
6742: bom_cto_src_orgs bcso
6743: where S.organization_id = C.organization_id
6744: and S.inventory_item_id = C.inventory_item_id
6745: and C.inventory_item_id = pModelId
6746: and C.inventory_item_id = S.inventory_item_id

Line 6960: bom_cto_src_orgs bcso

6956: from
6957: mtl_parameters MP1,
6958: cst_item_costs C,
6959: mtl_system_items S,
6960: bom_cto_src_orgs bcso
6961: where S.organization_id = C.organization_id
6962: and S.inventory_item_id = C.inventory_item_id
6963: and C.inventory_item_id = pModelId
6964: and C.inventory_item_id = S.inventory_item_id

Line 7120: bom_cto_src_orgs bcso

7116: from
7117: mtl_parameters MP1,
7118: cst_item_cost_details C,
7119: mtl_system_items S,
7120: bom_cto_src_orgs bcso
7121: where S.organization_id = C.organization_id
7122: and S.inventory_item_id = C.inventory_item_id
7123: and bcso.model_item_id = pModelId
7124: and bcso.line_id = pLineId

Line 7244: bom_cto_src_orgs bcso

7240: from
7241: mtl_parameters MP1,
7242: cst_item_cost_details C,
7243: mtl_system_items S,
7244: bom_cto_src_orgs bcso
7245: where S.organization_id = C.organization_id
7246: and S.inventory_item_id = C.inventory_item_id
7247: and bcso.model_item_id = pModelId
7248: and bcso.line_id = pLineId

Line 7571: bom_cto_src_orgs bcso

7567: SYSDATE, -- program_update_date
7568: ic.organization_id
7569: from
7570: mtl_item_categories ic,
7571: bom_cto_src_orgs bcso
7572: where ic.inventory_item_id = pModelId --bugfix 2706981: swapped the positions
7573: and ic.organization_id = bcso.organization_id
7574: and bcso.model_item_id = ic.inventory_item_id --bugfix 2706981: replaced pModelId with col join
7575: and bcso.line_id = pLineId -- as in bugfix 2215274

Line 7642: bom_cto_src_orgs bcso

7638: from
7639: mtl_item_categories ic,
7640: mtl_category_sets_b mcsb,
7641: mtl_default_category_sets mdcs,
7642: bom_cto_src_orgs bcso
7643: where pModelId = ic.inventory_item_id
7644: and ic.organization_id = bcso.organization_id
7645: and bcso.model_item_id = pModelId
7646: and bcso.line_id = pLineId

Line 7707: bom_cto_src_orgs bcso

7703: NULL, -- program_id
7704: SYSDATE, -- program_update_date
7705: ri.organization_id
7706: from mtl_related_items ri,
7707: bom_cto_src_orgs bcso
7708: where ri.inventory_item_id = pModelId
7709: and bcso.model_item_id = pModelId
7710: and bcso.line_id = pLineId
7711: and ri.organization_id = bcso.organization_id

Line 7818: bom_cto_src_orgs bcso

7814: SYSDATE, -- program_update_date
7815: isi.ENCUMBRANCE_ACCOUNT
7816: from
7817: mtl_item_sub_inventories isi,
7818: bom_cto_src_orgs bcso
7819: where isi.organization_id = bcso.organization_id
7820: and isi.inventory_item_id = pModelId
7821: and bcso.model_item_id = pModelId
7822: and bcso.line_id = pLineId

Line 7878: bom_cto_src_orgs bcso

7874: NULL, -- program_id
7875: SYSDATE -- program_update_date
7876: from
7877: mtl_secondary_locators sl,
7878: bom_cto_src_orgs bcso
7879: where sl.organization_id = bcso.organization_id
7880: and pModelId = sl.inventory_item_id
7881: and bcso.model_item_id = pModelId
7882: and bcso.line_id = pLineId

Line 7916: BOM_CTO_SRC_ORGS BCSO

7912: t_cross_ref_type,
7913: t_cross_ref,
7914: t_org_independent_flag
7915: FROM MTL_CROSS_REFERENCES_B CR,
7916: BOM_CTO_SRC_ORGS BCSO
7917: WHERE (CR.ORGANIZATION_ID = bcso.ORGANIZATION_ID OR CR.ORGANIZATION_ID IS NULL)
7918: AND CR.INVENTORY_ITEM_ID = PMODELID
7919: AND BCSO.MODEL_ITEM_ID = PMODELID
7920: AND BCSO.LINE_ID = PLINEID

Line 8102: bom_cto_src_orgs bcso

8098: NULL, -- program_id
8099: SYSDATE -- program_update_date
8100: from
8101: mtl_item_sub_defaults sd,
8102: bom_cto_src_orgs bcso
8103: where sd.organization_id = bcso.organization_id
8104: and sd.inventory_item_id = pModelId
8105: and bcso.model_item_id = pModelId
8106: and bcso.line_id = pLineId

Line 8160: bom_cto_src_orgs bcso

8156: NULL, -- program_id
8157: SYSDATE -- program_update_date
8158: from
8159: mtl_item_loc_defaults ld,
8160: bom_cto_src_orgs bcso
8161: where ld.organization_id = bcso.organization_id
8162: and ld.inventory_item_id = bcso.model_item_id
8163: and bcso.model_item_id = pModelId
8164: and bcso.line_id = pLineId

Line 9378: bom_cto_src_orgs bcso,

9374: gLoginId --last_update_login
9375: from
9376: mtl_parameters mp1,
9377: mtl_system_items_tl m,
9378: bom_cto_src_orgs bcso,
9379: fnd_languages l,
9380: mtl_item_revisions_b mr, --3338108
9381: mtl_parameters mp2 --4109427
9382: where m.inventory_item_id = pModelId

Line 10178: bom_cto_src_orgs bcso

10174: from
10175: mtl_system_items_b m, -- Model
10176: mtl_system_items_b config,
10177: bom_cto_order_lines bcol,
10178: bom_cto_src_orgs bcso
10179: where m.inventory_item_id = p_model_id
10180: and bcso.model_item_id = p_model_id
10181: and bcso.line_id = p_line_id
10182: and bcso.line_id = bcol.line_id