[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW(X_ROWID IN OUT NOCOPY VARCHAR2,
X_INTERFACE_TRANSACTION_ID IN OUT NOCOPY NUMBER,
X_GROUP_ID IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_CREATION_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_REQUEST_ID IN NUMBER,
X_PROGRAM_APPLICATION_ID IN NUMBER,
X_PROGRAM_ID IN NUMBER,
X_PROGRAM_UPDATE_DATE IN DATE,
X_TRANSACTION_TYPE IN VARCHAR2,
X_TRANSACTION_DATE IN DATE,
X_PROCESSING_STATUS_CODE IN VARCHAR2,
X_PROCESSING_MODE_CODE IN VARCHAR2,
X_PROCESSING_REQUEST_ID IN NUMBER,
X_TRANSACTION_STATUS_CODE IN VARCHAR2,
X_CATEGORY_ID IN NUMBER,
X_QUANTITY IN NUMBER,
X_UNIT_OF_MEASURE IN VARCHAR2,
X_INTERFACE_SOURCE_CODE IN VARCHAR2,
X_INTERFACE_SOURCE_LINE_ID IN NUMBER,
X_INV_TRANSACTION_ID IN NUMBER,
X_ITEM_ID IN NUMBER,
X_ITEM_DESCRIPTION IN VARCHAR2,
X_ITEM_REVISION IN VARCHAR2,
X_UOM_CODE IN VARCHAR2,
X_EMPLOYEE_ID IN NUMBER,
X_AUTO_TRANSACT_CODE IN VARCHAR2,
X_SHIPMENT_HEADER_ID IN NUMBER,
X_SHIPMENT_LINE_ID IN NUMBER,
X_SHIP_TO_LOCATION_ID IN NUMBER,
X_PRIMARY_QUANTITY IN NUMBER,
X_PRIMARY_UNIT_OF_MEASURE IN VARCHAR2,
X_RECEIPT_SOURCE_CODE IN VARCHAR2,
X_VENDOR_ID IN NUMBER,
X_VENDOR_SITE_ID IN NUMBER,
X_FROM_ORGANIZATION_ID IN NUMBER,
X_FROM_SUBINVENTORY IN VARCHAR2,
X_TO_ORGANIZATION_ID IN NUMBER,
X_INTRANSIT_OWNING_ORG_ID IN NUMBER,
X_ROUTING_HEADER_ID IN NUMBER,
X_ROUTING_STEP_ID IN NUMBER,
X_SOURCE_DOCUMENT_CODE IN VARCHAR2,
X_PARENT_TRANSACTION_ID IN NUMBER,
X_PO_HEADER_ID IN NUMBER,
X_PO_REVISION_NUM IN NUMBER,
X_PO_RELEASE_ID IN NUMBER,
X_PO_LINE_ID IN NUMBER,
X_PO_LINE_LOCATION_ID IN NUMBER,
X_PO_UNIT_PRICE IN NUMBER,
X_CURRENCY_CODE IN VARCHAR2,
X_CURRENCY_CONVERSION_TYPE IN VARCHAR2,
X_CURRENCY_CONVERSION_RATE IN NUMBER,
X_CURRENCY_CONVERSION_DATE IN DATE,
X_PO_DISTRIBUTION_ID IN NUMBER,
X_REQUISITION_LINE_ID IN NUMBER,
X_REQ_DISTRIBUTION_ID IN NUMBER,
X_CHARGE_ACCOUNT_ID IN NUMBER,
X_SUBSTITUTE_UNORDERED_CODE IN VARCHAR2,
X_RECEIPT_EXCEPTION_FLAG IN VARCHAR2,
X_ACCRUAL_STATUS_CODE IN VARCHAR2,
X_INSPECTION_STATUS_CODE IN VARCHAR2,
X_INSPECTION_QUALITY_CODE IN VARCHAR2,
X_DESTINATION_TYPE_CODE IN VARCHAR2,
X_DELIVER_TO_PERSON_ID IN NUMBER,
X_LOCATION_ID IN NUMBER,
X_DELIVER_TO_LOCATION_ID IN NUMBER,
X_SUBINVENTORY IN VARCHAR2,
X_LOCATOR_ID IN NUMBER,
X_WIP_ENTITY_ID IN NUMBER,
X_WIP_LINE_ID IN NUMBER,
X_DEPARTMENT_CODE IN VARCHAR2,
X_WIP_REPETITIVE_SCHEDULE_ID IN NUMBER,
X_WIP_OPERATION_SEQ_NUM IN NUMBER,
X_WIP_RESOURCE_SEQ_NUM IN NUMBER,
X_BOM_RESOURCE_ID IN NUMBER,
X_SHIPMENT_NUM IN VARCHAR2,
X_FREIGHT_CARRIER_CODE IN VARCHAR2,
X_BILL_OF_LADING IN VARCHAR2,
X_PACKING_SLIP IN VARCHAR2,
X_SHIPPED_DATE IN DATE,
X_EXPECTED_RECEIPT_DATE IN DATE,
X_ACTUAL_COST IN NUMBER,
X_TRANSFER_COST IN NUMBER,
X_TRANSPORTATION_COST IN NUMBER,
X_TRANSPORTATION_ACCOUNT_ID IN NUMBER,
X_NUM_OF_CONTAINERS IN NUMBER,
X_WAYBILL_AIRBILL_NUM IN VARCHAR2,
X_VENDOR_ITEM_NUM IN VARCHAR2,
X_VENDOR_LOT_NUM IN VARCHAR2,
X_RMA_REFERENCE IN VARCHAR2,
X_COMMENTS IN VARCHAR2,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE1 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE2 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE3 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE4 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE5 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE6 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE7 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE8 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE9 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE10 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE11 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE12 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE13 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE14 IN VARCHAR2,
X_SHIP_HEAD_ATTRIBUTE15 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE1 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE2 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE3 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE4 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE5 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE6 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE7 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE8 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE9 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE10 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE11 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE12 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE13 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE14 IN VARCHAR2,
X_SHIP_LINE_ATTRIBUTE15 IN VARCHAR2,
X_USSGL_TRANSACTION_CODE IN VARCHAR2,
X_GOVERNMENT_CONTEXT IN VARCHAR2,
X_REASON_ID IN NUMBER,
X_DESTINATION_CONTEXT IN VARCHAR2,
X_SOURCE_DOC_QUANTITY IN NUMBER,
X_SOURCE_DOC_UNIT_OF_MEASURE IN VARCHAR2,
X_MOVEMENT_ID IN NUMBER,
X_HEADER_INTERFACE_ID IN NUMBER,
X_VENDOR_CUM_SHIPPED_QTY IN NUMBER,
X_ITEM_NUM IN VARCHAR2,
X_DOCUMENT_NUM IN VARCHAR2,
X_DOCUMENT_LINE_NUM IN NUMBER,
X_TRUCK_NUM IN VARCHAR2,
X_SHIP_TO_LOCATION_CODE IN VARCHAR2,
X_CONTAINER_NUM IN VARCHAR2,
X_SUBSTITUTE_ITEM_NUM IN VARCHAR2,
X_NOTICE_UNIT_PRICE IN NUMBER,
X_ITEM_CATEGORY IN VARCHAR2,
X_LOCATION_CODE IN VARCHAR2,
X_VENDOR_NAME IN VARCHAR2,
X_VENDOR_NUM IN VARCHAR2,
X_VENDOR_SITE_CODE IN VARCHAR2,
X_FROM_ORGANIZATION_CODE IN VARCHAR2,
X_TO_ORGANIZATION_CODE IN VARCHAR2,
X_INTRANSIT_OWNING_ORG_CODE IN VARCHAR2,
X_ROUTING_CODE IN VARCHAR2,
X_ROUTING_STEP IN VARCHAR2,
X_RELEASE_NUM IN NUMBER,
X_DOCUMENT_SHIPMENT_LINE_NUM IN NUMBER,
X_DOCUMENT_DISTRIBUTION_NUM IN NUMBER,
X_DELIVER_TO_PERSON_NAME IN VARCHAR2,
X_DELIVER_TO_LOCATION_CODE IN VARCHAR2,
X_USE_MTL_LOT IN NUMBER,
X_USE_MTL_SERIAL IN NUMBER,
X_LOCATOR IN VARCHAR2,
X_REASON_NAME IN VARCHAR2,
X_VALIDATION_FLAG IN VARCHAR2,
X_SUBSTITUTE_ITEM_ID IN NUMBER,
X_QUANTITY_SHIPPED IN NUMBER,
X_QUANTITY_INVOICED IN NUMBER,
X_TAX_NAME IN VARCHAR2,
X_TAX_AMOUNT IN NUMBER,
X_REQ_NUM IN VARCHAR2,
X_REQ_LINE_NUM IN NUMBER,
X_REQ_DISTRIBUTION_NUM IN NUMBER,
X_WIP_ENTITY_NAME IN VARCHAR2,
X_WIP_LINE_CODE IN VARCHAR2,
X_RESOURCE_CODE IN VARCHAR2,
X_SHIPMENT_LINE_STATUS_CODE IN VARCHAR2,
X_BARCODE_LABEL IN VARCHAR2,
X_COUNTRY_OF_ORIGIN_CODE IN VARCHAR2,
X_FROM_LOCATOR_ID IN NUMBER,
X_QA_COLLECTION_ID IN NUMBER,
X_OE_ORDER_HEADER_ID IN NUMBER,
X_OE_ORDER_LINE_ID IN NUMBER,
X_CUSTOMER_ID IN NUMBER,
X_CUSTOMER_SITE_ID IN NUMBER,
X_CUSTOMER_ITEM_NUM IN VARCHAR2,
X_CREATE_DEBIT_MEMO_FLAG IN VARCHAR2,
X_PUT_AWAY_RULE_ID IN NUMBER,
X_PUT_AWAY_STRATEGY_ID IN NUMBER,
X_LPN_ID IN NUMBER,
X_TRANSFER_LPN_ID IN NUMBER,
X_COST_GROUP_ID IN NUMBER,
X_MOBILE_TXN IN VARCHAR2,
X_MMTT_TEMP_ID IN NUMBER,
X_TRANSFER_COST_GROUP_ID IN NUMBER,
X_SECONDARY_QUANTITY IN NUMBER,
X_SECONDARY_UNIT_OF_MEASURE IN VARCHAR2,
X_SECONDARY_UOM_CODE IN VARCHAR2,
X_QC_GRADE IN VARCHAR2,
X_OE_ORDER_NUM IN NUMBER,
X_OE_ORDER_LINE_NUM IN NUMBER,
X_CUSTOMER_ACCOUNT_NUMBER IN NUMBER,
X_CUSTOMER_PARTY_NAME IN VARCHAR2,
X_SOURCE_TRANSACTION_NUM IN VARCHAR2,
X_PARENT_SOURCE_TXN_NUM IN VARCHAR2,
X_PARENT_INTERFACE_TXN_ID IN NUMBER,
X_CUSTOMER_ITEM_ID IN NUMBER,
X_INTERFACE_AVAIL_QTY IN NUMBER,
X_INTERFACE_TRANS_QTY IN NUMBER,
X_FROM_LOCATOR IN VARCHAR2,
X_LPN_GROUP_ID IN NUMBER,
X_ORDER_TRANSACTION_ID IN NUMBER,
X_LICENSE_PLATE_NUMBER IN VARCHAR2,
X_TFR_LICENSE_PLATE_NUMBER IN VARCHAR2,
X_AMOUNT IN NUMBER,
X_JOB_ID IN NUMBER,
X_PROJECT_ID IN NUMBER,
X_TASK_ID IN NUMBER,
X_ASN_ATTACH_ID IN NUMBER,
X_TIMECARD_ID IN NUMBER,
X_TIMECARD_OVN IN NUMBER,
X_INTERFACE_AVAIL_AMT IN NUMBER,
X_INTERFACE_TRANS_AMT IN NUMBER,
P_ORG_ID IN MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE, --
/* Added the following columns for complex work */
P_MATCHING_BASIS IN VARCHAR2 DEFAULT NULL ,
P_AMOUNT_SHIPPED IN NUMBER DEFAULT NULL,
P_REQUESTED_AMOUNT IN NUMBER DEFAULT NULL,
P_MATERIAL_STORED_AMOUNT IN NUMBER DEFAULT NULL,
P_REPLENISH_ORDER_LINE_ID IN NUMBER DEFAULT NULL,
P_EXPRESS_TRANSACTION IN VARCHAR2 DEFAULT NULL,
X_LCM_SHIPMENT_LINE_ID IN NUMBER DEFAULT NULL, -- lcm changes
X_UNIT_LANDED_COST IN NUMBER DEFAULT NULL -- lcm changes
) IS
CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE
WHERE interface_transaction_id = X_Interface_Transaction_Id;
CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;
INSERT INTO RCV_TRANSACTIONS_INTERFACE(
INTERFACE_TRANSACTION_ID,
GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
TRANSACTION_TYPE,
TRANSACTION_DATE,
PROCESSING_STATUS_CODE,
PROCESSING_MODE_CODE,
PROCESSING_REQUEST_ID,
TRANSACTION_STATUS_CODE,
CATEGORY_ID,
QUANTITY,
UNIT_OF_MEASURE,
INTERFACE_SOURCE_CODE,
INTERFACE_SOURCE_LINE_ID,
INV_TRANSACTION_ID,
ITEM_ID,
ITEM_DESCRIPTION,
ITEM_REVISION,
UOM_CODE,
EMPLOYEE_ID,
AUTO_TRANSACT_CODE,
SHIPMENT_HEADER_ID,
SHIPMENT_LINE_ID,
SHIP_TO_LOCATION_ID,
PRIMARY_QUANTITY,
PRIMARY_UNIT_OF_MEASURE,
RECEIPT_SOURCE_CODE,
VENDOR_ID,
VENDOR_SITE_ID,
FROM_ORGANIZATION_ID,
TO_ORGANIZATION_ID,
INTRANSIT_OWNING_ORG_ID,
ROUTING_HEADER_ID,
ROUTING_STEP_ID,
SOURCE_DOCUMENT_CODE,
PARENT_TRANSACTION_ID,
PO_HEADER_ID,
PO_REVISION_NUM,
PO_RELEASE_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_UNIT_PRICE,
CURRENCY_CODE,
CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE,
PO_DISTRIBUTION_ID,
REQUISITION_LINE_ID,
REQ_DISTRIBUTION_ID,
CHARGE_ACCOUNT_ID,
SUBSTITUTE_UNORDERED_CODE,
RECEIPT_EXCEPTION_FLAG,
ACCRUAL_STATUS_CODE,
INSPECTION_STATUS_CODE,
INSPECTION_QUALITY_CODE,
DESTINATION_TYPE_CODE,
DELIVER_TO_PERSON_ID,
LOCATION_ID,
DELIVER_TO_LOCATION_ID,
FROM_SUBINVENTORY,
SUBINVENTORY,
FROM_LOCATOR_ID,
LOCATOR_ID,
WIP_ENTITY_ID,
WIP_LINE_ID,
DEPARTMENT_CODE,
WIP_REPETITIVE_SCHEDULE_ID,
WIP_OPERATION_SEQ_NUM,
WIP_RESOURCE_SEQ_NUM,
BOM_RESOURCE_ID,
SHIPMENT_NUM,
FREIGHT_CARRIER_CODE,
BILL_OF_LADING,
PACKING_SLIP,
SHIPPED_DATE,
EXPECTED_RECEIPT_DATE,
ACTUAL_COST,
TRANSFER_COST,
TRANSPORTATION_COST,
TRANSPORTATION_ACCOUNT_ID,
NUM_OF_CONTAINERS,
WAYBILL_AIRBILL_NUM,
VENDOR_ITEM_NUM,
VENDOR_LOT_NUM,
RMA_REFERENCE,
COMMENTS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
SHIP_HEAD_ATTRIBUTE_CATEGORY,
SHIP_HEAD_ATTRIBUTE1,
SHIP_HEAD_ATTRIBUTE2,
SHIP_HEAD_ATTRIBUTE3,
SHIP_HEAD_ATTRIBUTE4,
SHIP_HEAD_ATTRIBUTE5,
SHIP_HEAD_ATTRIBUTE6,
SHIP_HEAD_ATTRIBUTE7,
SHIP_HEAD_ATTRIBUTE8,
SHIP_HEAD_ATTRIBUTE9,
SHIP_HEAD_ATTRIBUTE10,
SHIP_HEAD_ATTRIBUTE11,
SHIP_HEAD_ATTRIBUTE12,
SHIP_HEAD_ATTRIBUTE13,
SHIP_HEAD_ATTRIBUTE14,
SHIP_HEAD_ATTRIBUTE15,
SHIP_LINE_ATTRIBUTE_CATEGORY,
SHIP_LINE_ATTRIBUTE1,
SHIP_LINE_ATTRIBUTE2,
SHIP_LINE_ATTRIBUTE3,
SHIP_LINE_ATTRIBUTE4,
SHIP_LINE_ATTRIBUTE5,
SHIP_LINE_ATTRIBUTE6,
SHIP_LINE_ATTRIBUTE7,
SHIP_LINE_ATTRIBUTE8,
SHIP_LINE_ATTRIBUTE9,
SHIP_LINE_ATTRIBUTE10,
SHIP_LINE_ATTRIBUTE11,
SHIP_LINE_ATTRIBUTE12,
SHIP_LINE_ATTRIBUTE13,
SHIP_LINE_ATTRIBUTE14,
SHIP_LINE_ATTRIBUTE15,
USSGL_TRANSACTION_CODE,
GOVERNMENT_CONTEXT,
REASON_ID,
DESTINATION_CONTEXT,
SOURCE_DOC_QUANTITY,
SOURCE_DOC_UNIT_OF_MEASURE,
MOVEMENT_ID,
HEADER_INTERFACE_ID,
VENDOR_CUM_SHIPPED_QTY,
ITEM_NUM,
DOCUMENT_NUM,
DOCUMENT_LINE_NUM,
TRUCK_NUM,
SHIP_TO_LOCATION_CODE,
CONTAINER_NUM,
SUBSTITUTE_ITEM_NUM,
NOTICE_UNIT_PRICE,
ITEM_CATEGORY,
LOCATION_CODE,
VENDOR_NAME,
VENDOR_NUM,
VENDOR_SITE_CODE,
FROM_ORGANIZATION_CODE,
TO_ORGANIZATION_CODE,
INTRANSIT_OWNING_ORG_CODE,
ROUTING_CODE,
ROUTING_STEP,
RELEASE_NUM,
DOCUMENT_SHIPMENT_LINE_NUM,
DOCUMENT_DISTRIBUTION_NUM,
DELIVER_TO_PERSON_NAME,
DELIVER_TO_LOCATION_CODE,
USE_MTL_LOT,
USE_MTL_SERIAL,
LOCATOR,
REASON_NAME,
VALIDATION_FLAG,
SUBSTITUTE_ITEM_ID,
QUANTITY_SHIPPED,
QUANTITY_INVOICED,
TAX_NAME,
TAX_AMOUNT,
REQ_NUM,
REQ_LINE_NUM,
REQ_DISTRIBUTION_NUM,
WIP_ENTITY_NAME,
WIP_LINE_CODE,
RESOURCE_CODE,
SHIPMENT_LINE_STATUS_CODE,
BARCODE_LABEL,
COUNTRY_OF_ORIGIN_CODE,
QA_COLLECTION_ID,
OE_ORDER_HEADER_ID,
OE_ORDER_LINE_ID,
CUSTOMER_ID,
CUSTOMER_SITE_ID,
CUSTOMER_ITEM_NUM,
CREATE_DEBIT_MEMO_FLAG,
PUT_AWAY_RULE_ID,
PUT_AWAY_STRATEGY_ID,
LPN_ID,
TRANSFER_LPN_ID,
COST_GROUP_ID,
MOBILE_TXN,
MMTT_TEMP_ID,
TRANSFER_COST_GROUP_ID,
SECONDARY_QUANTITY,
SECONDARY_UNIT_OF_MEASURE,
SECONDARY_UOM_CODE,
QC_GRADE,
OE_ORDER_NUM,
OE_ORDER_LINE_NUM,
CUSTOMER_ACCOUNT_NUMBER,
CUSTOMER_PARTY_NAME,
SOURCE_TRANSACTION_NUM,
PARENT_SOURCE_TRANSACTION_NUM,
PARENT_INTERFACE_TXN_ID,
CUSTOMER_ITEM_ID,
INTERFACE_AVAILABLE_QTY,
INTERFACE_TRANSACTION_QTY,
FROM_LOCATOR,
LPN_GROUP_ID,
ORDER_TRANSACTION_ID,
LICENSE_PLATE_NUMBER,
TRANSFER_LICENSE_PLATE_NUMBER,
AMOUNT,
JOB_ID,
PROJECT_ID,
TASK_ID,
ASN_ATTACH_ID,
TIMECARD_ID,
TIMECARD_OVN,
INTERFACE_AVAILABLE_AMT,
INTERFACE_TRANSACTION_AMT,
ORG_ID, --
MATCHING_BASIS ,
AMOUNT_SHIPPED ,
REQUESTED_AMOUNT,
MATERIAL_STORED_AMOUNT,
REPLENISH_ORDER_LINE_ID,
EXPRESS_TRANSACTION, --Bug 5550783
LCM_SHIPMENT_LINE_ID, -- lcm changes
UNIT_LANDED_COST -- lcm changes
)
VALUES (
X_INTERFACE_TRANSACTION_ID,
X_GROUP_ID,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_LOGIN,
X_REQUEST_ID,
X_PROGRAM_APPLICATION_ID,
X_PROGRAM_ID,
X_PROGRAM_UPDATE_DATE,
X_TRANSACTION_TYPE,
X_TRANSACTION_DATE,
X_PROCESSING_STATUS_CODE,
X_PROCESSING_MODE_CODE,
X_PROCESSING_REQUEST_ID,
X_TRANSACTION_STATUS_CODE,
X_CATEGORY_ID,
X_QUANTITY,
X_UNIT_OF_MEASURE,
X_INTERFACE_SOURCE_CODE,
X_INTERFACE_SOURCE_LINE_ID,
X_INV_TRANSACTION_ID,
X_ITEM_ID,
X_ITEM_DESCRIPTION,
X_ITEM_REVISION,
X_UOM_CODE,
X_EMPLOYEE_ID,
X_AUTO_TRANSACT_CODE,
X_SHIPMENT_HEADER_ID,
X_SHIPMENT_LINE_ID,
X_SHIP_TO_LOCATION_ID,
X_PRIMARY_QUANTITY,
X_PRIMARY_UNIT_OF_MEASURE,
X_RECEIPT_SOURCE_CODE,
X_VENDOR_ID,
X_VENDOR_SITE_ID,
X_FROM_ORGANIZATION_ID,
X_TO_ORGANIZATION_ID,
X_INTRANSIT_OWNING_ORG_ID,
X_ROUTING_HEADER_ID,
X_ROUTING_STEP_ID,
X_SOURCE_DOCUMENT_CODE,
X_PARENT_TRANSACTION_ID,
X_PO_HEADER_ID,
X_PO_REVISION_NUM,
X_PO_RELEASE_ID,
X_PO_LINE_ID,
X_PO_LINE_LOCATION_ID,
X_PO_UNIT_PRICE,
X_CURRENCY_CODE,
X_CURRENCY_CONVERSION_TYPE,
X_CURRENCY_CONVERSION_RATE,
X_CURRENCY_CONVERSION_DATE,
X_PO_DISTRIBUTION_ID,
X_REQUISITION_LINE_ID,
X_REQ_DISTRIBUTION_ID,
X_CHARGE_ACCOUNT_ID,
X_SUBSTITUTE_UNORDERED_CODE,
X_RECEIPT_EXCEPTION_FLAG,
X_ACCRUAL_STATUS_CODE,
X_INSPECTION_STATUS_CODE,
X_INSPECTION_QUALITY_CODE,
X_DESTINATION_TYPE_CODE,
X_DELIVER_TO_PERSON_ID,
X_LOCATION_ID,
X_DELIVER_TO_LOCATION_ID,
X_FROM_SUBINVENTORY,
X_SUBINVENTORY,
X_FROM_LOCATOR_ID,
X_LOCATOR_ID,
X_WIP_ENTITY_ID,
X_WIP_LINE_ID,
X_DEPARTMENT_CODE,
X_WIP_REPETITIVE_SCHEDULE_ID,
X_WIP_OPERATION_SEQ_NUM,
X_WIP_RESOURCE_SEQ_NUM,
X_BOM_RESOURCE_ID,
X_SHIPMENT_NUM,
X_FREIGHT_CARRIER_CODE,
X_BILL_OF_LADING,
X_PACKING_SLIP,
X_SHIPPED_DATE,
X_EXPECTED_RECEIPT_DATE,
X_ACTUAL_COST,
X_TRANSFER_COST,
X_TRANSPORTATION_COST,
X_TRANSPORTATION_ACCOUNT_ID,
X_NUM_OF_CONTAINERS,
X_WAYBILL_AIRBILL_NUM,
X_VENDOR_ITEM_NUM,
X_VENDOR_LOT_NUM,
X_RMA_REFERENCE,
X_COMMENTS,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_SHIP_HEAD_ATTRIBUTE_CATEGORY,
X_SHIP_HEAD_ATTRIBUTE1,
X_SHIP_HEAD_ATTRIBUTE2,
X_SHIP_HEAD_ATTRIBUTE3,
X_SHIP_HEAD_ATTRIBUTE4,
X_SHIP_HEAD_ATTRIBUTE5,
X_SHIP_HEAD_ATTRIBUTE6,
X_SHIP_HEAD_ATTRIBUTE7,
X_SHIP_HEAD_ATTRIBUTE8,
X_SHIP_HEAD_ATTRIBUTE9,
X_SHIP_HEAD_ATTRIBUTE10,
X_SHIP_HEAD_ATTRIBUTE11,
X_SHIP_HEAD_ATTRIBUTE12,
X_SHIP_HEAD_ATTRIBUTE13,
X_SHIP_HEAD_ATTRIBUTE14,
X_SHIP_HEAD_ATTRIBUTE15,
X_SHIP_LINE_ATTRIBUTE_CATEGORY,
X_SHIP_LINE_ATTRIBUTE1,
X_SHIP_LINE_ATTRIBUTE2,
X_SHIP_LINE_ATTRIBUTE3,
X_SHIP_LINE_ATTRIBUTE4,
X_SHIP_LINE_ATTRIBUTE5,
X_SHIP_LINE_ATTRIBUTE6,
X_SHIP_LINE_ATTRIBUTE7,
X_SHIP_LINE_ATTRIBUTE8,
X_SHIP_LINE_ATTRIBUTE9,
X_SHIP_LINE_ATTRIBUTE10,
X_SHIP_LINE_ATTRIBUTE11,
X_SHIP_LINE_ATTRIBUTE12,
X_SHIP_LINE_ATTRIBUTE13,
X_SHIP_LINE_ATTRIBUTE14,
X_SHIP_LINE_ATTRIBUTE15,
X_USSGL_TRANSACTION_CODE,
X_GOVERNMENT_CONTEXT,
X_REASON_ID,
X_DESTINATION_CONTEXT,
X_SOURCE_DOC_QUANTITY,
X_SOURCE_DOC_UNIT_OF_MEASURE,
X_MOVEMENT_ID,
X_HEADER_INTERFACE_ID,
X_VENDOR_CUM_SHIPPED_QTY,
X_ITEM_NUM,
X_DOCUMENT_NUM,
X_DOCUMENT_LINE_NUM,
X_TRUCK_NUM,
X_SHIP_TO_LOCATION_CODE,
X_CONTAINER_NUM,
X_SUBSTITUTE_ITEM_NUM,
X_NOTICE_UNIT_PRICE,
X_ITEM_CATEGORY,
X_LOCATION_CODE,
X_VENDOR_NAME,
X_VENDOR_NUM,
X_VENDOR_SITE_CODE,
X_FROM_ORGANIZATION_CODE,
X_TO_ORGANIZATION_CODE,
X_INTRANSIT_OWNING_ORG_CODE,
X_ROUTING_CODE,
X_ROUTING_STEP,
X_RELEASE_NUM,
X_DOCUMENT_SHIPMENT_LINE_NUM,
X_DOCUMENT_DISTRIBUTION_NUM,
X_DELIVER_TO_PERSON_NAME,
X_DELIVER_TO_LOCATION_CODE,
X_USE_MTL_LOT,
X_USE_MTL_SERIAL,
X_LOCATOR,
X_REASON_NAME,
X_VALIDATION_FLAG,
X_SUBSTITUTE_ITEM_ID,
X_QUANTITY_SHIPPED,
X_QUANTITY_INVOICED,
X_TAX_NAME,
X_TAX_AMOUNT,
X_REQ_NUM,
X_REQ_LINE_NUM,
X_REQ_DISTRIBUTION_NUM,
X_WIP_ENTITY_NAME,
X_WIP_LINE_CODE,
X_RESOURCE_CODE,
X_SHIPMENT_LINE_STATUS_CODE,
X_BARCODE_LABEL,
X_COUNTRY_OF_ORIGIN_CODE,
X_QA_COLLECTION_ID,
X_OE_ORDER_HEADER_ID,
X_OE_ORDER_LINE_ID,
X_CUSTOMER_ID,
X_CUSTOMER_SITE_ID,
X_CUSTOMER_ITEM_NUM,
X_CREATE_DEBIT_MEMO_FLAG,
X_PUT_AWAY_RULE_ID,
X_PUT_AWAY_STRATEGY_ID,
X_LPN_ID,
X_TRANSFER_LPN_ID,
X_COST_GROUP_ID,
X_MOBILE_TXN,
X_MMTT_TEMP_ID,
X_TRANSFER_COST_GROUP_ID,
X_SECONDARY_QUANTITY,
X_SECONDARY_UNIT_OF_MEASURE,
X_SECONDARY_UOM_CODE,
X_QC_GRADE,
X_OE_ORDER_NUM,
X_OE_ORDER_LINE_NUM,
X_CUSTOMER_ACCOUNT_NUMBER,
X_CUSTOMER_PARTY_NAME,
X_SOURCE_TRANSACTION_NUM,
X_PARENT_SOURCE_TXN_NUM,
X_PARENT_INTERFACE_TXN_ID,
X_CUSTOMER_ITEM_ID,
X_INTERFACE_AVAIL_QTY,
X_INTERFACE_TRANS_QTY,
X_FROM_LOCATOR,
X_LPN_GROUP_ID,
X_ORDER_TRANSACTION_ID,
X_LICENSE_PLATE_NUMBER,
X_TFR_LICENSE_PLATE_NUMBER,
X_AMOUNT,
X_JOB_ID,
X_PROJECT_ID,
X_TASK_ID,
X_ASN_ATTACH_ID,
X_TIMECARD_ID,
X_TIMECARD_OVN,
X_INTERFACE_AVAIL_AMT,
X_INTERFACE_TRANS_AMT,
P_ORG_ID, --
/* Added the following columns for complex work */
P_MATCHING_BASIS ,
P_AMOUNT_SHIPPED ,
P_REQUESTED_AMOUNT ,
P_MATERIAL_STORED_AMOUNT,
P_REPLENISH_ORDER_LINE_ID,
P_EXPRESS_TRANSACTION, --Bug 5550783
X_LCM_SHIPMENT_LINE_ID, -- lcm changes
X_UNIT_LANDED_COST -- lcm changes
);
END INSERT_ROW;