eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_COPY_BILL dependencies on FND_PROFILE

Line 1053: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', l_default_wip_params);

1049: --bug:5364225 When copying across orgs, wip supply type will be copied from
1050: --component/component operation. If Default Wip Values profile is set to Yes, then
1051: --supply subinventory and supply locator will be defaulted from item otherwise they
1052: --will be nulled out. When copying within same org, the values will be copied from comp/comp operation.
1053: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', l_default_wip_params);
1054:
1055: -- reset from_sequence_id to common_bill_sequence_id
1056: sql_stmt_num := 10;
1057:

Line 1348: l_prof_val := fnd_profile.value(l_prof_name);

1344: l_prof_check := substr(l_context, 1, 12);
1345:
1346: if (l_prof_check = ':$PROFILES$.') then
1347: l_prof_name := ltrim(l_context, ':$PROFILES$.');
1348: l_prof_val := fnd_profile.value(l_prof_name);
1349:
1350: end if;
1351: end if;
1352: --changes bug 10078346 end

Line 5300: if(nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)

5296: AND msib1.organization_id = to_org_id;
5297:
5298: -- No ATO Optional components in PTO bill
5299: --modified the following for BOM ER 9904085
5300: if(nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
5301: then
5302: INSERT INTO mtl_interface_errors
5303: (unique_id,
5304: organization_id,

Line 5486: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)

5482: AND msi2.bom_item_type = option_class
5483: AND msi1.pick_components_flag = 'Y'
5484: )
5485: OR (
5486: (nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
5487: and
5488: (msi2.replenish_to_order_flag = 'Y'
5489: AND msi2.bom_item_type = STANDARD
5490: AND msi1.pick_components_flag = 'Y'

Line 5528: AND nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 --added for BOM ER 9904085

5524:
5525: UPDATE bom_components_b bic
5526: SET bic.optional = 1
5527: WHERE bic.bill_sequence_id = to_sequence_id
5528: AND nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 --added for BOM ER 9904085
5529: AND EXISTS (
5530: SELECT NULL
5531: FROM mtl_system_items msi1, -- assembly
5532: mtl_system_items msi2 -- component

Line 6920: AND oav.responsibility_id = fnd_profile.value('RESP_ID')

6916: x_item_rev_tbl(l_index), x_item_rev_id_tbl(l_index),
6917: x_item_rev_lbl_tbl(l_index), x_item_exists_tbl(l_index)
6918: FROM org_access_view oav
6919: WHERE oav.organization_id = x_org_list_tbl(l_index)
6920: AND oav.responsibility_id = fnd_profile.value('RESP_ID')
6921: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');
6922: l_index := x_org_list_tbl.next(l_index);
6923: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6924: EXCEPTION

Line 6921: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');

6917: x_item_rev_lbl_tbl(l_index), x_item_exists_tbl(l_index)
6918: FROM org_access_view oav
6919: WHERE oav.organization_id = x_org_list_tbl(l_index)
6920: AND oav.responsibility_id = fnd_profile.value('RESP_ID')
6921: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');
6922: l_index := x_org_list_tbl.next(l_index);
6923: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6924: EXCEPTION
6925: WHEN NO_DATA_FOUND THEN

Line 7507: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', l_default_wip_params);

7503:
7504: BEGIN
7505: SAVEPOINT begin_revised_item_bill_copy;
7506:
7507: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', l_default_wip_params);
7508:
7509: -- reset from_sequence_id to common_bill_sequence_id
7510: sql_stmt_num := 10;
7511:

Line 7714: l_prof_val := fnd_profile.value(l_prof_name);

7710: l_prof_check := substr(l_context, 1, 12);
7711:
7712: if (l_prof_check = ':$PROFILES$.') then
7713: l_prof_name := ltrim(l_context, ':$PROFILES$.');
7714: l_prof_val := fnd_profile.value(l_prof_name);
7715:
7716: end if;
7717: end if;
7718: --changes bug 10078346 end

Line 11873: AND( (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'),2) <> 1

11869: AND (( s2.pick_components_flag = 'Y'
11870: AND s1.pick_components_flag = 'Y')
11871: OR ( s2.replenish_to_order_flag = 'Y'
11872: AND s1.replenish_to_order_flag = 'Y'))))
11873: AND( (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'),2) <> 1
11874: AND
11875: NOT(s2.bom_item_type = 4 AND s2.pick_components_flag = 'Y' AND s1.bom_item_type = 4 AND s1.replenish_to_order_flag = 'Y')
11876: )
11877: OR

Line 11878: (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'),2) = 1)

11874: AND
11875: NOT(s2.bom_item_type = 4 AND s2.pick_components_flag = 'Y' AND s1.bom_item_type = 4 AND s1.replenish_to_order_flag = 'Y')
11876: )
11877: OR
11878: (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'),2) = 1)
11879: )
11880: /* BOM ER 9904085,10175288,ATO Item under PTO Model*/
11881: AND( ((nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
11882: AND

Line 11881: AND( ((nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)

11877: OR
11878: (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'),2) = 1)
11879: )
11880: /* BOM ER 9904085,10175288,ATO Item under PTO Model*/
11881: AND( ((nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1)
11882: AND
11883: (NOT(s2.bom_item_type = 1 AND s2.pick_components_flag = 'Y' AND nvl(bic.optional, 1) = 2 AND s1.bom_item_type = 4 AND s1.replenish_to_order_flag = 'Y'))
11884: )
11885: OR

Line 11886: (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)

11882: AND
11883: (NOT(s2.bom_item_type = 1 AND s2.pick_components_flag = 'Y' AND nvl(bic.optional, 1) = 2 AND s1.bom_item_type = 4 AND s1.replenish_to_order_flag = 'Y'))
11884: )
11885: OR
11886: (nvl(fnd_profile.VALUE('BOM:MANDATORY_ATO_IN_PTO'), 2) = 1)
11887: )
11888: /* END BOM ER 9904085,10175288,ATO Item under PTO Model*/
11889: );
11890: