DBA Data[Home] [Help]

APPS.BOMPXINQ dependencies on MTL_PARAMETERS

Line 520: from mtl_parameters

516: -- set to 'Y'.
517: --bug 2951874 corrected the following sql.
518:
519: select count(*) into cnt
520: from mtl_parameters
521: where organization_id = cost_organization_id
522: and organization_id = org_id;
523:
524: if (cnt >0) then

Line 1085: FROM mtl_parameters

1081: l_org_code VARCHAR2(3);
1082: BEGIN
1083: SELECT organization_code
1084: INTO l_org_code
1085: FROM mtl_parameters
1086: WHERE organization_id = P_organization_id;
1087: RETURN l_org_code;
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN

Line 1664: FROM mtl_parameters

1660: l_bom_export_tab BOMPXINQ.BOMEXPORTTABTYPE;
1661:
1662: CURSOR organization_code_CUR IS
1663: SELECT organization_id
1664: FROM mtl_parameters
1665: WHERE organization_code = P_organization_code;
1666:
1667: CURSOR assembly_item_name_CUR IS
1668: SELECT inventory_item_id