DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on MTL_KANBAN_CARDS

Line 126: MTL_KANBAN_CARDS wflow_mkc,

122: wflow.Current_line_operation
123: FROM WIP_FLOW_SCHEDULES wflow,
124: WIP_ENTITIES wflow_we,
125: MTL_ITEM_LOCATIONS_KFV wflow_loc,
126: MTL_KANBAN_CARDS wflow_mkc,
127: WIP_LINES wflow_wl
128: WHERE wflow.wip_entity_id = l_wip_entity_id
129: AND Wflow.wip_entity_id = wflow_we.wip_entity_id
130: AND NVL(p_locator_id,wflow.completion_locator_id) = wflow_loc.inventory_location_id(+)

Line 367: p_kanban_card_id IN mtl_kanban_cards.kanban_card_id%TYPE

363:
364: /*=================================================================*/
365: PROCEDURE get_data_kanban(
366: x_out_tbl IN OUT NOCOPY output_tbl_type,
367: p_kanban_card_id IN mtl_kanban_cards.kanban_card_id%TYPE
368: )IS
369:
370: CURSOR kanban_curs IS
371: SELECT

Line 404: FROM MTL_KANBAN_CARDS kanban,

400: kanban.Source_type,
401: pv.vendor_name supplier,
402: kanban.supply_status,
403: kanban.kanban_card_number
404: FROM MTL_KANBAN_CARDS kanban,
405: MTL_ITEM_LOCATIONS_KFV kanban_loc,
406: MTL_ITEM_LOCATIONS_KFV kanban_sloc,
407: MTL_PARAMETERS kanban_sorg,
408: MTL_PARAMETERS kanban_org,