DBA Data[Home] [Help]

APPS.WIP_FLOW_VALIDATION dependencies on PJM_UNIT_EFF

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

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

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

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

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

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

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

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