DBA Data[Home] [Help]

APPS.CSP_AUTO_ASLMSL_PVT dependencies on CSP_SAFETY_FACTORS

Line 659: CSP_SAFETY_FACTORS csf

655: DECODE(DECODE(SIGN(cuh.AWU),-1,0,cuh.AWU),0,0,DECODE(cuh.item_cost,0,0,
656: DECODE(cpp.edq_factor,0,0,ROUND(cpp.Edq_Factor * (SQRT(52 * cuh.Awu * cuh.Item_Cost)/cuh.Item_Cost),4))))) max_quantity
657: from CSP_USAGE_HEADERS cuh,
658: CSP_PLANNING_PARAMETERS cpp,
659: CSP_SAFETY_FACTORS csf
660: Where cuh.header_data_type = 1
661: And cuh.process_status = 'O'
662: And cpp.organization_id = cuh.organization_id
663: And cpp.secondary_inventory = cuh.secondary_inventory

Line 697: CSP_SAFETY_FACTORS csf

693: DECODE(DECODE(SIGN(cuh.AWU),-1,0,cuh.AWU),0,0,DECODE(cuh.item_cost,0,0,
694: DECODE(cpp.edq_factor,0,0,ROUND(cpp.Edq_Factor * (SQRT(52 * cuh.Awu * cuh.Item_Cost)/cuh.Item_Cost),4))))) max_quantity
695: from CSP_USAGE_HEADERS cuh,
696: CSP_PLANNING_PARAMETERS cpp,
697: CSP_SAFETY_FACTORS csf
698: Where cuh.header_data_type = 4
699: And cuh.process_status = 'O'
700: And cpp.organization_id = cuh.organization_id
701: And cpp.node_type = 'ORGANIZATION_WH'