DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on WMS_OP_PLANS_B

Line 288: , wms_op_plans_b wop

284: BEGIN
285: SELECT rules.rule_id, rules.type_hdr_id BULK COLLECT
286: INTO g_t_opa_rule_id, g_t_opa_type_hdr_id
287: FROM wms_rules rules
288: , wms_op_plans_b wop
289: WHERE rules.organization_id IN (g_opa_org_id,-1)
290: AND rules.type_code = 7
291: AND rules.enabled_flag = 'Y'
292: AND rules.type_hdr_id = wop.operation_plan_id