DBA Data[Home] [Help]

APPS.WIP_FLOW_VALIDATION dependencies on PJM_UNIT_EFF

Line 1100: AND (pjm_unit_eff.enabled = 'N'

1096: INTO x_success
1097: FROM mtl_transactions_interface mti
1098: WHERE rowid = p_rowid
1099: AND ((end_item_unit_number IS NULL
1100: AND (pjm_unit_eff.enabled = 'N'
1101: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))
1102: OR (end_item_unit_number IS NOT NULL
1103: AND (pjm_unit_eff.enabled = 'Y'
1104: AND pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'Y'

Line 1101: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))

1097: FROM mtl_transactions_interface mti
1098: WHERE rowid = p_rowid
1099: AND ((end_item_unit_number IS NULL
1100: AND (pjm_unit_eff.enabled = 'N'
1101: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))
1102: OR (end_item_unit_number IS NOT NULL
1103: AND (pjm_unit_eff.enabled = 'Y'
1104: AND pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'Y'
1105: AND end_item_unit_number IN (SELECT unit_number

Line 1103: AND (pjm_unit_eff.enabled = 'Y'

1099: AND ((end_item_unit_number IS NULL
1100: AND (pjm_unit_eff.enabled = 'N'
1101: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))
1102: OR (end_item_unit_number IS NOT NULL
1103: AND (pjm_unit_eff.enabled = 'Y'
1104: AND pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'Y'
1105: AND end_item_unit_number IN (SELECT unit_number
1106: FROM pjm_unit_numbers_lov_v N, mtl_parameters P
1107: WHERE P.organization_id = mti.organization_id and

Line 1104: AND pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'Y'

1100: AND (pjm_unit_eff.enabled = 'N'
1101: OR pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'N'))
1102: OR (end_item_unit_number IS NOT NULL
1103: AND (pjm_unit_eff.enabled = 'Y'
1104: AND pjm_unit_eff.unit_effective_item(mti.inventory_item_id,mti.organization_id) = 'Y'
1105: AND end_item_unit_number IN (SELECT unit_number
1106: FROM pjm_unit_numbers_lov_v N, mtl_parameters P
1107: WHERE P.organization_id = mti.organization_id and
1108: P.master_organization_id = N.master_organization_id)