DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on MTL_KANBAN_CARDS

Line 1763: from mtl_kanban_cards mkc

1759: and transaction_source_type_id = 5
1760: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1761: and kanban_card_id is not null
1762: and not exists (select 'X'
1763: from mtl_kanban_cards mkc
1764: where mkc.kanban_card_id = mti.kanban_card_id
1765: and mkc.source_type = 4
1766: and mkc.organization_id = mti.organization_id
1767: and mkc.subinventory_name = mti.subinventory_code

Line 1794: from mtl_kanban_cards mkc

1790: and transaction_source_type_id = 5
1791: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
1792: and kanban_card_id is not null
1793: and not exists (select 'X'
1794: from mtl_kanban_cards mkc
1795: where mkc.kanban_card_id = mti.kanban_card_id
1796: and mkc.organization_id = mti.organization_id
1797: and ( mkc.supply_status in (4, 5)
1798: or ( mkc.supply_status = 2