eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_VERSION_COMPARISON_PKG dependencies on OKE_K_DELIVERABLES_VLH

Line 5291: deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE,

5287:
5288: PROCEDURE comp_line_deliverables(vHeader_id IN NUMBER,vVersion1 IN NUMBER, vVersion2 IN NUMBER,vCurrentLineId IN NUMBER)
5289: IS
5290: TYPE r_deliverable IS RECORD(
5291: deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE,
5292: item_id oke_k_deliverables_vlh.item_id%TYPE,
5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,

Line 5292: item_id oke_k_deliverables_vlh.item_id%TYPE,

5288: PROCEDURE comp_line_deliverables(vHeader_id IN NUMBER,vVersion1 IN NUMBER, vVersion2 IN NUMBER,vCurrentLineId IN NUMBER)
5289: IS
5290: TYPE r_deliverable IS RECORD(
5291: deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE,
5292: item_id oke_k_deliverables_vlh.item_id%TYPE,
5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,

Line 5293: description oke_k_deliverables_vlh.description%TYPE,

5289: IS
5290: TYPE r_deliverable IS RECORD(
5291: deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE,
5292: item_id oke_k_deliverables_vlh.item_id%TYPE,
5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,

Line 5294: project_number oke_k_deliverables_vlh.project_number%TYPE,

5290: TYPE r_deliverable IS RECORD(
5291: deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE,
5292: item_id oke_k_deliverables_vlh.item_id%TYPE,
5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,

Line 5295: project_name oke_k_deliverables_vlh.project_name%TYPE,

5291: deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE,
5292: item_id oke_k_deliverables_vlh.item_id%TYPE,
5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,

Line 5296: task_number oke_k_deliverables_vlh.task_number%TYPE,

5292: item_id oke_k_deliverables_vlh.item_id%TYPE,
5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,

Line 5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,

5293: description oke_k_deliverables_vlh.description%TYPE,
5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,

Line 5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,

5294: project_number oke_k_deliverables_vlh.project_number%TYPE,
5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,

Line 5299: status_code oke_k_deliverables_vlh.status_code%TYPE,

5295: project_name oke_k_deliverables_vlh.project_name%TYPE,
5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,

Line 5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,

5296: task_number oke_k_deliverables_vlh.task_number%TYPE,
5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,

Line 5301: direction oke_k_deliverables_vlh.direction%TYPE,

5297: --task_name oke_k_deliverables_vlh.task_name%TYPE,
5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,

Line 5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,

5298: delivery_date oke_k_deliverables_vlh.delivery_date%TYPE,
5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,

Line 5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,

5299: status_code oke_k_deliverables_vlh.status_code%TYPE,
5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,

Line 5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,

5300: parent_deliverable_id oke_k_deliverables_vlh.parent_deliverable_id%TYPE,
5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,

Line 5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,

5301: direction oke_k_deliverables_vlh.direction%TYPE,
5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,

Line 5306: start_date oke_k_deliverables_vlh.start_date%TYPE,

5302: ship_to_org_id oke_k_deliverables_vlh.ship_to_org_id %TYPE,
5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,

Line 5307: end_date oke_k_deliverables_vlh.end_date%TYPE,

5303: ship_to_location_id oke_k_deliverables_vlh.ship_to_location_id%TYPE,
5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,

Line 5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,

5304: ship_from_org_id oke_k_deliverables_vlh.ship_from_org_id%TYPE,
5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,

Line 5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,

5305: ship_from_location_id oke_k_deliverables_vlh.ship_from_location_id%TYPE,
5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,

Line 5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,

5306: start_date oke_k_deliverables_vlh.start_date%TYPE,
5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,

Line 5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,

5307: end_date oke_k_deliverables_vlh.end_date%TYPE,
5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,

Line 5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,

5308: need_by_date oke_k_deliverables_vlh.need_by_date%TYPE,
5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,

Line 5313: quantity oke_k_deliverables_vlh.quantity%TYPE,

5309: priority_code oke_k_deliverables_vlh.priority_code%TYPE,
5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,

Line 5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,

5310: currency_code oke_k_deliverables_vlh.currency_code%TYPE,
5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,

Line 5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,

5311: unit_price oke_k_deliverables_vlh.unit_price%TYPE,
5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,

Line 5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,

5312: uom_code oke_k_deliverables_vlh.uom_code%TYPE,
5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,

Line 5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,

5313: quantity oke_k_deliverables_vlh.quantity%TYPE,
5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,

Line 5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,

5314: country_of_origin_code oke_k_deliverables_vlh.country_of_origin_code%TYPE,
5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,

Line 5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,

5315: subcontracted_flag oke_k_deliverables_vlh.subcontracted_flag%TYPE,
5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,

Line 5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,

5316: dependency_flag oke_k_deliverables_vlh.dependency_flag%TYPE,
5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,

Line 5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,

5317: billable_flag oke_k_deliverables_vlh.billable_flag%TYPE,
5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,

Line 5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,

5318: billing_event_id oke_k_deliverables_vlh.billing_event_id%TYPE,
5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,

Line 5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,

5319: drop_shipped_flag oke_k_deliverables_vlh.drop_shipped_flag%TYPE,
5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,

Line 5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,

5320: completed_flag oke_k_deliverables_vlh.completed_flag%TYPE,
5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,

Line 5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,

5321: available_for_ship_flag oke_k_deliverables_vlh.available_for_ship_flag%TYPE,
5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,

Line 5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,

5322: create_demand oke_k_deliverables_vlh.create_demand%TYPE,
5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,

Line 5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,

5323: ready_to_bill oke_k_deliverables_vlh.ready_to_bill%TYPE,
5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,

Line 5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,

5324: ready_to_procure oke_k_deliverables_vlh.ready_to_procure%TYPE,
5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,

Line 5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,

5325: mps_transaction_id oke_k_deliverables_vlh.mps_transaction_id%TYPE,
5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,

Line 5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,

5326: shipping_request_id oke_k_deliverables_vlh.shipping_request_id%TYPE,
5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,

Line 5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,

5327: unit_number oke_k_deliverables_vlh.unit_number%TYPE,
5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,

Line 5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,

5328: ndb_schedule_designator oke_k_deliverables_vlh.ndb_schedule_designator%TYPE,
5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,

Line 5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,

5329: shippable_flag oke_k_deliverables_vlh.shippable_flag%TYPE,
5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,

Line 5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,

5330: cfe_req_flag oke_k_deliverables_vlh.cfe_req_flag%TYPE,
5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,

Line 5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,

5331: inspection_req_flag oke_k_deliverables_vlh.inspection_req_flag%TYPE,
5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,

Line 5336: frequency oke_k_deliverables_vlh.frequency%TYPE,

5332: interim_rpt_req_flag oke_k_deliverables_vlh.interim_rpt_req_flag%TYPE,
5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,

Line 5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,

5333: lot_applies_flag oke_k_deliverables_vlh.lot_applies_flag%TYPE,
5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,

Line 5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,

5334: customer_approval_req_flag oke_k_deliverables_vlh.customer_approval_req_flag%TYPE,
5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,

Line 5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,

5335: date_of_first_submission oke_k_deliverables_vlh.date_of_first_submission%TYPE,
5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,

Line 5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,

5336: frequency oke_k_deliverables_vlh.frequency%TYPE,
5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,

Line 5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,

5337: acq_doc_number oke_k_deliverables_vlh.acq_doc_number%TYPE,
5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,

Line 5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,

5338: submission_flag oke_k_deliverables_vlh.submission_flag%TYPE,
5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,

Line 5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,

5339: data_item_subtitle oke_k_deliverables_vlh.data_item_subtitle%TYPE,
5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,

Line 5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,

5340: total_num_of_copies oke_k_deliverables_vlh.total_num_of_copies%TYPE,
5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,

Line 5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,

5341: cdrl_category oke_k_deliverables_vlh.cdrl_category%TYPE,
5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,

Line 5346: comments oke_k_deliverables_vlh.comments%TYPE,

5342: data_item_name oke_k_deliverables_vlh.data_item_name%TYPE,
5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,

Line 5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,

5343: export_flag oke_k_deliverables_vlh.export_flag%TYPE,
5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,

Line 5348: status oke_k_deliverables_vlh.status%TYPE,

5344: export_license_num oke_k_deliverables_vlh.export_license_num%TYPE,
5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,

Line 5349: volume oke_k_deliverables_vlh.volume%TYPE,

5345: export_license_res oke_k_deliverables_vlh.export_license_res%TYPE,
5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,

Line 5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,

5346: comments oke_k_deliverables_vlh.comments%TYPE,
5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,

Line 5351: weight oke_k_deliverables_vlh.weight%TYPE,

5347: sfwt_flag oke_k_deliverables_vlh.sfwt_flag%TYPE,
5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,

Line 5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,

5348: status oke_k_deliverables_vlh.status%TYPE,
5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,

Line 5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,

5349: volume oke_k_deliverables_vlh.volume%TYPE,
5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,

Line 5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,

5350: volume_uom_code oke_k_deliverables_vlh.volume_uom_code%TYPE,
5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,

Line 5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,

5351: weight oke_k_deliverables_vlh.weight%TYPE,
5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,

Line 5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,

5352: weight_uom_code oke_k_deliverables_vlh.weight_uom_code%TYPE,
5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,

Line 5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,

5353: expenditure_type oke_k_deliverables_vlh.expenditure_type%TYPE,
5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,
5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,

Line 5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,

5354: expenditure_organization_id oke_k_deliverables_vlh.expenditure_organization_id%TYPE,
5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,
5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,
5362: promised_shipment_date oke_k_deliverables_vlh.promised_shipment_date%TYPE

Line 5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,

5355: expenditure_item_date oke_k_deliverables_vlh.expenditure_item_date%TYPE,
5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,
5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,
5362: promised_shipment_date oke_k_deliverables_vlh.promised_shipment_date%TYPE
5363:

Line 5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,

5356: destination_type_code oke_k_deliverables_vlh.destination_type_code%TYPE,
5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,
5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,
5362: promised_shipment_date oke_k_deliverables_vlh.promised_shipment_date%TYPE
5363:
5364: );

Line 5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,

5357: rate_type oke_k_deliverables_vlh.rate_type%TYPE,
5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,
5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,
5362: promised_shipment_date oke_k_deliverables_vlh.promised_shipment_date%TYPE
5363:
5364: );
5365:

Line 5362: promised_shipment_date oke_k_deliverables_vlh.promised_shipment_date%TYPE

5358: rate_date oke_k_deliverables_vlh.rate_date%TYPE,
5359: exchange_rate oke_k_deliverables_vlh.exchange_rate%TYPE,
5360: expected_shipment_date oke_k_deliverables_vlh.expected_shipment_date%TYPE,
5361: initiate_shipment_date oke_k_deliverables_vlh.initiate_shipment_date%TYPE,
5362: promised_shipment_date oke_k_deliverables_vlh.promised_shipment_date%TYPE
5363:
5364: );
5365:
5366: r_deliverable_1 r_deliverable;

Line 5372: current_deliverable_1 oke_k_deliverables_vlh.deliverable_id%TYPE;

5368:
5369: type c_deliverables_1 is ref cursor;
5370:
5371: v_deliverables_1 c_deliverables_1;
5372: current_deliverable_1 oke_k_deliverables_vlh.deliverable_id%TYPE;
5373: current_deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE;
5374:
5375: CURSOR c_deliverables_2 IS
5376: SELECT deliverable_id

Line 5373: current_deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE;

5369: type c_deliverables_1 is ref cursor;
5370:
5371: v_deliverables_1 c_deliverables_1;
5372: current_deliverable_1 oke_k_deliverables_vlh.deliverable_id%TYPE;
5373: current_deliverable_num oke_k_deliverables_vlh.deliverable_num%TYPE;
5374:
5375: CURSOR c_deliverables_2 IS
5376: SELECT deliverable_id
5377: from oke_k_deliverables_bh

Line 5636: FROM oke_k_deliverables_vlh

5632: promised_shipment_date
5633:
5634:
5635: INTO r_deliverable_1
5636: FROM oke_k_deliverables_vlh
5637: WHERE deliverable_id=current_deliverable_1
5638: AND major_version=vVersion1;
5639:
5640:

Line 5800: FROM oke_k_deliverables_vlh

5796: promised_shipment_date
5797:
5798:
5799: INTO r_deliverable_2
5800: FROM oke_k_deliverables_vlh
5801: WHERE deliverable_id=current_deliverable_1
5802: AND major_version=vVersion2;
5803:
5804: IF (r_deliverable_1.deliverable_num <> r_deliverable_2.deliverable_num)