DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on FND_PROFILE

Line 1063: to_number(fnd_profile.value('WIP_SEE_ENG_ITEMS')) = wip_constants.yes )); --FP Bug 6502612

1059: where b.assembly_item_id = p_itemID
1060: and b.organization_id = p_orgID
1061: and nvl(b.alternate_bom_designator, '@@@@@') = NVL(p_altBomDesig, '@@@@@')
1062: and (b.assembly_type = wip_constants.manufacturing_bill or --FP Bug 6502612
1063: to_number(fnd_profile.value('WIP_SEE_ENG_ITEMS')) = wip_constants.yes )); --FP Bug 6502612
1064:
1065: /******
1066: select a.organization_id, a.bill_sequence_id
1067: into l_cmnOrgID, l_cmnBillID

Line 1154: if (to_number(fnd_profile.value('WIP_SEE_ENG_ITEMS')) = wip_constants.yes) then

1150: and nvl(alternate_bom_designator, '@@@@@') = NVL(p_altBomDesig, '@@@@@'); /* Bug 5139022 Added NVL functions */
1151:
1152: /*Fix for bug 10245572, if WIP: See Engineering Item set to Yes, always set l_bom_or_eng_flag to be 2 so that
1153: bom explosion code can handle the explosion for a mixture of BOM and Engineering Bill Structure.*/
1154: if (to_number(fnd_profile.value('WIP_SEE_ENG_ITEMS')) = wip_constants.yes) then
1155: l_bom_or_eng_flag := WIP_CONSTANTS.ENGINEERING_BILL;
1156: end if;
1157:
1158: --explode the bom. This API has a few shortcomings. Namely: