DBA Data[Home] [Help]

APPS.FLM_KANBAN_TRANSFER dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 1130: mtl_kanban_card_activity mkca

1126: FROM oe_order_headers_all oeh,
1127: oe_order_lines_all oel ,
1128: wsh_delivery_details wdd,
1129: mtl_kanban_cards mkc,
1130: mtl_kanban_card_activity mkca
1131: WHERE oeh.source_document_id = mkca.document_header_id
1132: AND oeh.header_id = oel.header_id
1133: AND oel.source_document_line_id = mkca.document_detail_id
1134: AND wdd.source_line_id = oel.line_id

Line 1154: mtl_kanban_card_activity mkca

1150: mtrl.line_id
1151: FROM mtl_txn_request_headers mtrh,
1152: mtl_txn_request_lines mtrl,
1153: mtl_kanban_cards mkc,
1154: mtl_kanban_card_activity mkca
1155: WHERE mtrh.header_id = mkca.document_header_id
1156: AND mtrl.line_id = mkca.document_detail_id
1157: AND mtrh.header_status = mtrl.line_status
1158: AND mtrh.header_status = 7 -- Pre Approved