DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on STANDARD

Line 408: l_standard_operation_id NUMBER;

404: l_task_id NUMBER;
405: l_line_num NUMBER;
406:
407: l_organization_id NUMBER;
408: l_standard_operation_id NUMBER;
409: l_transaction_temp_id NUMBER;
410: -- WF Fix Start
411: l_missing_quantity NUMBER;
412: l_oe_header_id NUMBER;

Line 508: standard_operation_id,

504:
505:
506: CURSOR get_mmtt_rows IS
507: SELECT organization_id,
508: standard_operation_id,
509: transaction_temp_id,
510: operation_plan_id,
511: move_order_line_id
512: FROM mtl_material_transactions_temp

Line 1526: If any of these lead to qty less than 0 then compute using standard conversion.

1522: /*The below logic does the following:
1523: If MTRL UOM = MMTT txn UOM then
1524: MTRL new qty = MTRL old qty - MMTT txn qty
1525: If its dual UOM Item then MTRL new sec qty = MTRL old sec qty - MMTT sec qty
1526: If any of these lead to qty less than 0 then compute using standard conversion.
1527: Else
1528: for Primary based fulfillment AND If MTRL UOM is primary UOM then
1529: MTRL new qty = MTRL old qty - MMTT primary qty
1530: MTRL new sec qty = MTRL old sec qty - MMTT secondary qty, If it goes below 0 then derive MTRL new qty using conversion