DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on MTL_PARAMETERS

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

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

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

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

Line 5237: from mtl_parameters mp1,

5233: Begin
5234: Select distinct mp1.master_organization_id
5235: Bulk Collect into
5236: x_orgs_list
5237: from mtl_parameters mp1,
5238: bom_cto_src_orgs bcso
5239: where bcso.line_id = p_model_line_id
5240: and bcso.organization_id = mp1.organization_id
5241: and mp1.master_organization_id not in