DBA Data[Home] [Help]

APPS.BOMPXINQ dependencies on MTL_PARAMETERS

Line 506: from mtl_parameters

502: -- set to 'Y'.
503: --bug 2951874 corrected the following sql.
504:
505: select count(*) into cnt
506: from mtl_parameters
507: where organization_id = cost_organization_id
508: and organization_id = org_id;
509:
510: if (cnt >0) then

Line 1041: FROM mtl_parameters

1037: l_org_code VARCHAR2(3);
1038: BEGIN
1039: SELECT organization_code
1040: INTO l_org_code
1041: FROM mtl_parameters
1042: WHERE organization_id = P_organization_id;
1043: RETURN l_org_code;
1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN

Line 1620: FROM mtl_parameters

1616: l_bom_export_tab BOMPXINQ.BOMEXPORTTABTYPE;
1617:
1618: CURSOR organization_code_CUR IS
1619: SELECT organization_id
1620: FROM mtl_parameters
1621: WHERE organization_code = P_organization_code;
1622:
1623: CURSOR assembly_item_name_CUR IS
1624: SELECT inventory_item_id