DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on MTL_PARAMETERS

Line 633: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol

629:
630: /*Update Create_BOM Flag for Shared Costing Organizations */
631: update bom_cto_src_orgs_b bcso_b1 set create_bom = 'Y'
632: where ( organization_id , line_id ) in ( select mp.cost_organization_id , bcso_b.line_id
633: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol
634: where bcso_b.top_model_line_id = pTopAtoLineId
635: and bcol.ato_line_id = pTopAtoLineId
636: and bcol.line_id = bcso_b.line_id
637: and bcol.config_creation in ( 1 , 2 )

Line 1099: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol

1095:
1096: /*Update Create_BOM Flag for Shared Costing Organizations */
1097: update bom_cto_src_orgs_b bcso_b1 set create_bom = 'Y'
1098: where ( organization_id , line_id ) in ( select mp.cost_organization_id , bcso_b.line_id
1099: from mtl_parameters mp, bom_cto_src_orgs_b bcso_b, bom_cto_order_lines bcol
1100: where bcso_b.top_model_line_id = pTopAtoLineId
1101: and bcol.ato_line_id = pTopAtoLineId
1102: and bcol.line_id = bcso_b.line_id
1103: and bcol.config_creation in ( 1 , 2 )

Line 5767: from mtl_parameters mp1,

5763: Begin
5764: Select distinct mp1.master_organization_id
5765: Bulk Collect into
5766: x_orgs_list
5767: from mtl_parameters mp1,
5768: bom_cto_src_orgs bcso
5769: where bcso.line_id = p_model_line_id
5770: and bcso.organization_id = mp1.organization_id
5771: and mp1.master_organization_id not in