DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on MTL_KANBAN_CARDS

Line 1809: from mtl_kanban_cards mkc

1805: and transaction_source_type_id = 5
1806: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1807: and kanban_card_id is not null
1808: and not exists (select 'X'
1809: from mtl_kanban_cards mkc
1810: where mkc.kanban_card_id = mti.kanban_card_id
1811: and mkc.source_type = 4
1812: and mkc.organization_id = mti.organization_id
1813: and mkc.subinventory_name = mti.subinventory_code

Line 1840: from mtl_kanban_cards mkc

1836: and transaction_source_type_id = 5
1837: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1838: and kanban_card_id is not null
1839: and not exists (select 'X'
1840: from mtl_kanban_cards mkc
1841: where mkc.kanban_card_id = mti.kanban_card_id
1842: and mkc.organization_id = mti.organization_id
1843: and ( mkc.supply_status in (4, 5)
1844: or ( mkc.supply_status = 2