eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FLM_MULTIPLE_SUPPLIERS dependencies on MTL_KANBAN_CARDS

Line 92: mtl_kanban_cards mkc

88: mks.number_of_cards actual_supplier_cards,
89: Count(mkc.kanban_card_id) existing_supplier_cards,
90: mks.number_of_cards - Nvl(Count(mkc.kanban_card_id),0) deficiency
91: FROM mtl_pull_seq_suppliers mks,
92: mtl_kanban_cards mkc
93: WHERE mks.pull_sequence_id = p_pull_seq_id
94: AND mks.pull_sequence_id = mkc.pull_sequence_id(+)
95: AND mks.supplier_id = mkc.supplier_id(+)
96: AND Nvl(mks.supplier_site_id, -1 ) = Nvl(mkc.supplier_site_id(+) ,-1)

Line 109: mtl_kanban_cards mkc

105: mks.future_no_of_cards actual_supplier_cards,
106: Count(mkc.kanban_card_id) existing_supplier_cards,
107: mks.future_no_of_cards - Nvl(Count(mkc.kanban_card_id),0) deficiency
108: FROM mtl_pull_seq_suppliers mks ,
109: mtl_kanban_cards mkc
110: WHERE mks.pull_sequence_id = p_pull_seq_id
111: AND mks.pull_sequence_id = mkc.pull_sequence_id(+)
112: AND mks.supplier_id = mkc.supplier_id(+)
113: and NVL(MKS.SUPPLIER_SITE_ID, -1 ) = NVL(MKC.SUPPLIER_SITE_ID(+) ,-1)