DBA Data[Home] [Help]

APPS.PO_CREATE_ISO dependencies on FND_PROFILE

Line 702: decode (fnd_profile.value('PO_CUSTOM_UNIT_PRICE'),'Y',round(l_unit_list_price,l_ext_precision),round(PO_CREATE_ISO.GET_CST_PRICE(RL.ITEM_ID,

698: MUM.UOM_CODE,
699: round(RL.QUANTITY,9),
700: --begin bug 3249134: changed the following values to be rounded
701: --< INVCONV R12 START> umoogala: Added Dest. OrgId and qty parameters
702: decode (fnd_profile.value('PO_CUSTOM_UNIT_PRICE'),'Y',round(l_unit_list_price,l_ext_precision),round(PO_CREATE_ISO.GET_CST_PRICE(RL.ITEM_ID,
703: RL.SOURCE_ORGANIZATION_ID,
704: RL.UNIT_MEAS_LOOKUP_CODE,
705: RL.DESTINATION_ORGANIZATION_ID,
706: RL.QUANTITY),

Line 708: decode (fnd_profile.value('PO_CUSTOM_UNIT_PRICE'),'Y',round(l_unit_selling_price,l_ext_precision),round(PO_CREATE_ISO.GET_CST_PRICE(RL.ITEM_ID,

704: RL.UNIT_MEAS_LOOKUP_CODE,
705: RL.DESTINATION_ORGANIZATION_ID,
706: RL.QUANTITY),
707: l_ext_precision)), --Bug10037733
708: decode (fnd_profile.value('PO_CUSTOM_UNIT_PRICE'),'Y',round(l_unit_selling_price,l_ext_precision),round(PO_CREATE_ISO.GET_CST_PRICE(RL.ITEM_ID,
709: RL.SOURCE_ORGANIZATION_ID,
710: RL.UNIT_MEAS_LOOKUP_CODE,
711: RL.DESTINATION_ORGANIZATION_ID,
712: RL.QUANTITY),

Line 738: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)

734: decode(l_op_unit_id, -1, NULL, l_op_unit_id),
735: l_source_secondary_uom, --MUM1.UOM_CODE,
736: round( l_source_secondary_quantity,9), --RL.SECONDARY_QUANTITY,
737: decode(si.grade_control_flag,'Y',RL.preferred_grade,NULL) -- RL.PREFERRED_GRADE
738: , decode(RL.URGENT_FLAG,'Y', fnd_profile.value('POR_URGENT_FLAG_SHIPMENT_PRIORITY_CODE'),null)
739: FROM PO_REQUISITION_LINES RL,
740: PO_REQUISITION_HEADERS RH,
741: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
742: MTL_SYSTEM_ITEMS SI,