DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on WIP_PARAMETERS

Line 366: WIP_PARAMETERS WP

362: into l_temp
363: from MTL_PARAMETERS MP ,
364: WSM_PARAMETERS WSM,
365: HR_ALL_ORGANIZATION_UNITS ORG,
366: WIP_PARAMETERS WP
367: where MP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
368: and ORG.ORGANIZATION_ID = WSM.ORGANIZATION_ID
369: and WP.ORGANIZATION_ID = WSM.ORGANIZATION_ID
370: and UPPER(MP.WSM_ENABLED_FLAG)='Y'

Line 496: -- p_po_creation_time: => pass the value of po_creation_time in wip_parameters for the org

492:
493: -- p_src_client_server: 1 => this procedure is being called from client side,
494: -- any other value => server side call.
495:
496: -- p_po_creation_time: => pass the value of po_creation_time in wip_parameters for the org
497:
498: procedure build_lbji_info(
499: p_routing_seq_id IN number,
500: p_common_bill_sequence_id IN number,

Line 863: from wip_parameters

859: --Bug 5207481:Actual quantity changes for bonus-Start of changes
860: -- CJ: Start changes for Component Shrinkage project --
861: /* select include_component_yield
862: into l_include_comp_yld
863: from wip_parameters
864: where organization_id = p_org;*/
865:
866: --IF (nvl(l_include_comp_yld, 1) = 1) THEN -- Include Component Yield
867: update wip_requirement_operations

Line 946: wip_parameters params

942: l_po_creation_time,
943: l_est_scrap_account,
944: l_est_scrap_var_account
945: from wip_accounting_classes wac,
946: wip_parameters params
947: where wac.class_code(+)= p_class_code
948: and wac.organization_id(+)= p_org
949: and params.organization_id = p_org;
950: EXCEPTION