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.JAI_OM_RG_PKG dependencies on MTL_INTERORG_PARAMETERS

Line 1107: The intransit_inv_account was picked from mtl_interorg_parameters through cursor

1103: 2. 01/04/2003 Aparajita for bug#2848921
1104: As per the logic above, for internal sales order the first two accounting entries are not
1105: required. But as per this bug, for ISO these two accounting entries should also get passed.
1106:
1107: The intransit_inv_account was picked from mtl_interorg_parameters through cursor
1108: c_get_iso_accounts for the combination of from and to organization. As per the requirement
1109: now, it should be picked from mtl_parameters for the receiving organization. Added cursor
1110: c_get_intransit_inv_account.
1111:

Line 1116: picked up from mtl_interorg_parameters, so using cursor c_get_iso_accounts.

1112: Added the check of fob_point along with in transit type.
1113:
1114: 3. 07/04/2003 Aparajita for bug#2893284
1115: Removed the cursor c_get_intransit_inv_account as the requiremnts are that it should be
1116: picked up from mtl_interorg_parameters, so using cursor c_get_iso_accounts.
1117:
1118: Removed the cursor c_get_intransit_type, as it was redundant and used c_get_iso_accounts.
1119:
1120: 4. 13/05/2003 Nagaraj.s for Bug#2912007

Line 1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

1186: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
1187: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1188: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

Line 1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

1187: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
1188: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

Line 1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

1188: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
1189: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
1190: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1191: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1192: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1193: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1194: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
1195: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1196: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;

Line 1228: FROM mtl_interorg_parameters

1224:
1225:
1226: CURSOR c_get_iso_accounts(p_from_org_id NUMBER, p_to_org_id NUMBER) IS
1227: SELECT intransit_type, fob_point, interorg_receivables_account, interorg_payables_account, intransit_inv_account
1228: FROM mtl_interorg_parameters
1229: WHERE from_organization_id = p_from_org_id
1230: AND to_organization_id = p_to_org_id;
1231:
1232: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

Line 1264: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;

1260:
1261:
1262:
1263: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
1264: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

Line 1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;

1261:
1262:
1263: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
1264: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

1262:
1263: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
1264: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

1263: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
1264: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

1264: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
1265: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
1266: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
1267: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
1268: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
1269: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1270: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
1271: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
1272: lv_source_manufacturing JAI_CMN_INVENTORY_ORGS.MANUFACTURING%TYPE;

Line 3810: FROM mtl_interorg_parameters

3806:
3807:
3808: CURSOR c_get_iso_accounts(p_from_org_id NUMBER, p_to_org_id NUMBER) IS
3809: SELECT intransit_type, fob_point, interorg_receivables_account, interorg_payables_account, intransit_inv_account
3810: FROM mtl_interorg_parameters
3811: WHERE from_organization_id = p_from_org_id
3812: AND to_organization_id = p_to_org_id;
3813:
3814: CURSOR debit_account_cur( cp_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE,

Line 3844: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;

3840: /*
3841: The following variables defined for cess trading to trading
3842: */
3843: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
3844: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

Line 3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;

3841: The following variables defined for cess trading to trading
3842: */
3843: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
3844: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

3842: */
3843: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
3844: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;

Line 3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

3843: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;
3844: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

3844: lv_dest_intransit_type MTL_INTERORG_PARAMETERS.INTRANSIT_TYPE%TYPE;
3845: ln_dest_fob_point MTL_INTERORG_PARAMETERS.FOB_POINT%TYPE;
3846: ln_dest_interorg_rcvbles_acc MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3847: ln_dest_interorg_payables_acc MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3848: ln_dest_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3849: ln_src_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3850: ln_dest_excise_in_rg23d JAI_CMN_INVENTORY_ORGS.EXCISE_IN_RG23D%TYPE;
3851: lv_source_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;
3852: lv_dest_trading JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;

Line 3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;

3861: v_order_line_id WSH_DELIVERY_DETAILS.SOURCE_LINE_ID%TYPE;
3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;

Line 3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;

3862: v_order_source_id OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID%TYPE;
3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;

Line 3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;

3863: v_intransit_type MTL_SHIPPING_NETWORK_VIEW.INTRANSIT_TYPE%TYPE;
3864: v_fob_point MTL_SHIPPING_NETWORK_VIEW.FOB_POINT%TYPE;
3865: v_interorg_receivables_account MTL_INTERORG_PARAMETERS.INTERORG_RECEIVABLES_ACCOUNT%TYPE;
3866: v_interorg_payables_account MTL_INTERORG_PARAMETERS.INTERORG_PAYABLES_ACCOUNT%TYPE;
3867: v_intransit_inv_account MTL_INTERORG_PARAMETERS.INTRANSIT_INV_ACCOUNT%TYPE;
3868: v_from_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3869: v_to_organization_id WSH_DELIVERY_DETAILS.ORGANIZATION_ID%TYPE;
3870: v_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3871: v_requisition_header_id PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID%TYPE;