APPS.WMS_CARTNZN_PUB dependencies on MTL_PARAMETERS

Line 3275: mtl_parameters mtlp

3271: CURSOR wct_rows IS
3272: SELECT wct.* FROM wms_cartonization_temp wct,
3273: mtl_txn_request_lines mtrl,
3274: mtl_secondary_inventories sub,
3275: mtl_parameters mtlp
3276: WHERE
3277: wct.move_order_line_id =mtrl.line_id
3278: AND mtrl.header_id = p_move_order_header_id
3279: AND wct.cartonization_id IS null

Line 3461: FROM mtl_parameters

3457: l_cartonize_manufacturing,
3458: --Bug 3528061 fix
3459: g_allocate_serial_flag,
3460: wms_cartnzn_pub.g_default_pick_op_plan_id
3461: FROM mtl_parameters
3462: WHERE organization_id = p_org_id;
3463:
3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3465: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;

Line 6006: mtl_parameters mtlp

6002: CURSOR wct_rows IS
6003: SELECT wct.* FROM wms_cartonization_temp wct,
6004: mtl_txn_request_lines mtrl,
6005: mtl_secondary_inventories sub,
6006: mtl_parameters mtlp
6007: WHERE
6008: wct.move_order_line_id =mtrl.line_id
6009: AND mtrl.header_id = p_move_order_header_id
6010: AND wct.cartonization_id IS null

Line 6028: mtl_parameters mtlp

6024: CURSOR wct_sub_rows IS
6025: SELECT wct.* FROM wms_cartonization_temp wct,
6026: mtl_txn_request_lines mtrl,
6027: mtl_secondary_inventories sub,
6028: mtl_parameters mtlp
6029: WHERE
6030: wct.move_order_line_id =mtrl.line_id
6031: AND mtrl.header_id = p_move_order_header_id
6032: AND wct.cartonization_id IS null

Line 6783: mtl_parameters mtlp

6779: CURSOR wct_rows IS
6780: SELECT wct.* FROM wms_cartonization_temp wct,
6781: mtl_txn_request_lines mtrl,
6782: mtl_secondary_inventories sub,
6783: mtl_parameters mtlp
6784: WHERE
6785: wct.move_order_line_id =mtrl.line_id
6786: AND mtrl.header_id = p_move_order_header_id
6787: AND wct.cartonization_id IS null

Line 7339: mtl_parameters mtlp

7335: CURSOR wct_rows IS
7336: SELECT wct.* FROM wms_cartonization_temp wct,
7337: mtl_txn_request_lines mtrl,
7338: mtl_secondary_inventories sub,
7339: mtl_parameters mtlp
7340: WHERE
7341: wct.move_order_line_id =mtrl.line_id
7342: AND mtrl.header_id = p_move_order_header_id
7343: AND wct.cartonization_id IS null

Line 7767: mtl_parameters mtlp,

7763: IS
7764: SELECT DISTINCT wct.pick_slip_number
7765: FROM wms_cartonization_temp wct,
7766: mtl_txn_request_lines mtrl,
7767: mtl_parameters mtlp,
7768: mtl_secondary_inventories sub
7769: WHERE mtrl.header_id = p_move_order_header_id
7770: AND mtrl.organization_id = p_org_id
7771: AND wct.move_order_line_id = mtrl.line_id

Line 7789: mtl_parameters mtlp,

7785: IS
7786: SELECT DISTINCT wct.pick_slip_number
7787: FROM wms_cartonization_temp wct,
7788: mtl_txn_request_lines mtrl,
7789: mtl_parameters mtlp,
7790: mtl_secondary_inventories sub
7791: WHERE mtrl.header_id = p_move_order_header_id
7792: AND mtrl.organization_id = p_org_id
7793: AND wct.move_order_line_id = mtrl.line_id

Line 8195: mtl_parameters mtlp

8191: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8192: FROM wms_cartonization_temp wct,
8193: mtl_txn_request_lines mtrl,
8194: mtl_secondary_inventories sub,
8195: mtl_parameters mtlp
8196: WHERE wct.move_order_line_id =mtrl.line_id
8197: AND mtrl.header_id = p_move_order_header_id
8198: AND mtlp.organization_id = wct.organization_id
8199: AND sub.organization_id = wct.organization_id

Line 8219: mtl_parameters mtlp

8215: SELECT wct.* BULK COLLECT INTO l_mmtt_table
8216: FROM wms_cartonization_temp wct,
8217: mtl_txn_request_lines mtrl,
8218: mtl_secondary_inventories sub,
8219: mtl_parameters mtlp
8220: WHERE wct.move_order_line_id =mtrl.line_id
8221: AND mtrl.header_id = p_move_order_header_id
8222: AND mtlp.organization_id = wct.organization_id
8223: AND sub.secondary_inventory_name = wct.subinventory_code