DBA Data[Home] [Help]

APPS.INV_LABEL_PVT9 dependencies on STANDARD

Line 177: , NULL operations_standard_operation

173: NULL operations_last_receipt_date
174: , -- Added for Bug 2795525
175: NULL operations_min_transfer_qty
176: , NULL operations_schedule_quantity
177: , NULL operations_standard_operation
178: , NULL operations_yield
179: , NULL operations_yield_enabled
180: ,
181: -- Requirements

Line 592: , wipops.standard_operation_id operations_standard_operation

588: TO_CHAR(wipops.last_unit_start_date, g_date_format_mask) operations_last_receipt_date
589: , -- Added for Bug 2795525
590: wipops.minimum_transfer_quantity operations_min_transfer_qty
591: , wipops.scheduled_quantity operations_schedule_quantity
592: , wipops.standard_operation_id operations_standard_operation
593: , wipops.operation_yield operations_yield
594: , wipops.operation_yield_enabled operations_yield_enabled
595: ,
596: -- Requirements

Line 833: AND msik3.inventory_item_id(+) = wipent.primary_item_id -- Bug 2440672 For Agilent -- Added Outer Join for non-Standard Jobs.

829: AND mln.lot_number(+) = NVL(wlc.lot_number, l_lot_number)
830: AND mmsv1.status_id(+) = mln.status_id
831: AND ccg.cost_group_id(+) = NVL(wlc.cost_group_id, l_cost_group_id)
832: AND poh.hazard_class_id(+) = msik2.hazard_class_id
833: AND msik3.inventory_item_id(+) = wipent.primary_item_id -- Bug 2440672 For Agilent -- Added Outer Join for non-Standard Jobs.
834: AND msik3.organization_id(+) = wipent.organization_id; -- Bug 2440672 For Agilent -- Added Outer Join for non-Standard Jobs.
835:
836: l_selected_fields inv_label.label_field_variable_tbl_type;
837: l_selected_fields_count NUMBER;

Line 834: AND msik3.organization_id(+) = wipent.organization_id; -- Bug 2440672 For Agilent -- Added Outer Join for non-Standard Jobs.

830: AND mmsv1.status_id(+) = mln.status_id
831: AND ccg.cost_group_id(+) = NVL(wlc.cost_group_id, l_cost_group_id)
832: AND poh.hazard_class_id(+) = msik2.hazard_class_id
833: AND msik3.inventory_item_id(+) = wipent.primary_item_id -- Bug 2440672 For Agilent -- Added Outer Join for non-Standard Jobs.
834: AND msik3.organization_id(+) = wipent.organization_id; -- Bug 2440672 For Agilent -- Added Outer Join for non-Standard Jobs.
835:
836: l_selected_fields inv_label.label_field_variable_tbl_type;
837: l_selected_fields_count NUMBER;
838: l_label_format_id NUMBER := 0;

Line 2023: ELSIF LOWER(l_selected_fields(i).column_name) = 'operations_standard_operation' THEN

2019: || l_selected_fields(i).variable_name
2020: || '">'
2021: || v_wip_content.operations_schedule_quantity
2022: || variable_e;
2023: ELSIF LOWER(l_selected_fields(i).column_name) = 'operations_standard_operation' THEN
2024: l_content_item_data :=
2025: l_content_item_data
2026: || variable_b
2027: || l_selected_fields(i).variable_name

Line 2029: || v_wip_content.operations_standard_operation

2025: l_content_item_data
2026: || variable_b
2027: || l_selected_fields(i).variable_name
2028: || '">'
2029: || v_wip_content.operations_standard_operation
2030: || variable_e;
2031: ELSIF LOWER(l_selected_fields(i).column_name) = 'operations_yield' THEN
2032: l_content_item_data :=
2033: l_content_item_data || variable_b || l_selected_fields(i).variable_name || '">' || v_wip_content.operations_yield