APPS.INV_LABEL_PVT1 dependencies on WIP_OSP_JOBS_VAL_V

Line 243: l_wip_entity_name wip_osp_jobs_val_v.wip_entity_name%TYPE;

239: l_wip_op_seq_num rcv_transactions.WIP_OPERATION_SEQ_NUM%type;
240: l_osp_dept_code VARCHAR2(10);
241: l_bom_resource_id NUMBER;
242: l_bom_resource_code VARCHAR2(20);
243: l_wip_entity_name wip_osp_jobs_val_v.wip_entity_name%TYPE;
244: l_wip_description wip_osp_jobs_val_v.description%TYPE;
245:
246: ---------------------------------------------------------------------------------------------
247: -- Project: 'Custom Labels' (A 11i10+ Project) |

Line 244: l_wip_description wip_osp_jobs_val_v.description%TYPE;

240: l_osp_dept_code VARCHAR2(10);
241: l_bom_resource_id NUMBER;
242: l_bom_resource_code VARCHAR2(20);
243: l_wip_entity_name wip_osp_jobs_val_v.wip_entity_name%TYPE;
244: l_wip_description wip_osp_jobs_val_v.description%TYPE;
245:
246: ---------------------------------------------------------------------------------------------
247: -- Project: 'Custom Labels' (A 11i10+ Project) |
248: -- Author: Dinesh ([email protected]) |

Line 372: , wip_osp_jobs_val_v wojv

368: , hr_locations_all hrl2
369: , po_vendor_sites_all pvs
370: , per_people_f ppf
371: , rcv_routing_headers rrh
372: , wip_osp_jobs_val_v wojv
373: WHERE wlc.parent_lpn_id(+) = rti.lpn_id
374: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669
375: AND pol.po_line_id(+) = rti.po_line_id
376: AND pha.po_header_id(+) = rti.po_header_id

Line 454: , wip_osp_jobs_val_v wojv

450: , hr_locations_all hrl2
451: , po_vendor_sites_all pvs
452: , per_people_f ppf
453: , rcv_routing_headers rrh
454: , wip_osp_jobs_val_v wojv
455: WHERE wlc.parent_lpn_id(+) = rti.transfer_lpn_id
456: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669
457: AND pol.po_line_id(+) = rti.po_line_id
458: AND pha.po_header_id(+) = rti.po_header_id

Line 513: , wip_osp_jobs_val_v wojv

509: , RTI.WIP_OPERATION_SEQ_NUM
510: , rti.DEPARTMENT_CODE
511: , rti.BOM_RESOURCE_ID
512: FROM rcv_transactions_interface rti
513: , wip_osp_jobs_val_v wojv
514: , mtl_transaction_lots_temp mtlt
515: , /***************************************/
516: (SELECT rti.GROUP_ID
517: , rti.interface_transaction_id

Line 555: , wip_osp_jobs_val_v wojv

551: -- MOAC changed po_vendor_sites to po_vendor_sites_all
552: , po_vendor_sites_all pvs
553: , hr_employees hre
554: , rcv_routing_headers rrh
555: , wip_osp_jobs_val_v wojv
556: WHERE rti.GROUP_ID IN (SELECT GROUP_ID
557: FROM rcv_transactions_interface
558: WHERE interface_transaction_id =
559: p_transaction_id)

Line 710: --, wip_osp_jobs_val_v wojv

706: , po_vendor_sites_all pvs
707: , per_people_f ppf
708: , rcv_routing_headers rrh
709: -- Bug 4516067, to improve performance, query the base table directly
710: --, wip_osp_jobs_val_v wojv
711: , wip_entities we -- Added for Bug#4516067
712: , wip_discrete_jobs wdj -- Added for Bug#4516067
713: , wms_license_plate_numbers wlpn -- Bug 3836623
714: , (SELECT cost_group_id, rcv_transaction_id

Line 896: --, wip_osp_jobs_val_v wojv

892: , po_vendor_sites_all pvs
893: , per_people_f ppf
894: , rcv_routing_headers rrh
895: -- Bug 4516067, to improve performance, query the base table directly
896: --, wip_osp_jobs_val_v wojv
897: , wip_entities we
898: , wip_discrete_jobs wdj
899: , wms_license_plate_numbers wlpn -- Bug 3836623
900: , (SELECT cost_group_id, rcv_transaction_id

Line 1067: --, wip_osp_jobs_val_v wojv

1063: , po_vendor_sites_all pvs
1064: , per_people_f ppf
1065: , rcv_routing_headers rrh
1066: -- Bug 4516067, to improve performance, query the base table directly
1067: --, wip_osp_jobs_val_v wojv
1068: , wip_entities we
1069: , wip_discrete_jobs wdj
1070: , wms_license_plate_numbers wlpn -- Bug 3836623
1071: WHERE mtln.product_transaction_id(+) = rt.transaction_id