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.GMD_VERSION_CONTROL dependencies on FM_MATL_DTL

Line 1368: FROM fm_matl_dtl

1364: WHERE formula_no = X_hdr_rec.formula_no;
1365:
1366: CURSOR Cur_get_dtl IS
1367: SELECT *
1368: FROM fm_matl_dtl
1369: WHERE formula_id = p_formula_id;
1370:
1371: --kkillams,bug 3738941
1372: CURSOR cur_form_att(cp_entity_name fnd_attached_documents.entity_name%TYPE,

Line 1379: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;

1375: FROM fnd_attached_documents fad
1376: WHERE fad.entity_name = cp_entity_name
1377: AND fad.pk1_value = cp_pk1_value;
1378:
1379: l_formulaline_id fm_matl_dtl.formulaline_id%TYPE;
1380: l_dummy NUMBER;
1381:
1382: TYPE detail_tab IS TABLE OF Cur_get_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
1383: X_dtl_tbl detail_tab;

Line 1531: INSERT INTO fm_matl_dtl(formulaline_id, formula_id, line_type, line_no,

1527: l_text_code := NULL;
1528: END IF;
1529: --
1530: -- Bug #2673008 (JKB) Added call to copy_text above.
1531: INSERT INTO fm_matl_dtl(formulaline_id, formula_id, line_type, line_no,
1532: inventory_item_id, qty, detail_uom,revision, release_type, scrap_factor,
1533: scale_type, cost_alloc, phantom_type, rework_type, text_code,
1534: organization_id,last_updated_by, created_by, last_update_date, creation_date,
1535: last_update_login, attribute1, attribute2, attribute3,

Line 1598: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));

1594: WHERE formula_id = X_formula_id;
1595: --END BUG#3077938
1596: --kkillams, Bug 3738941
1597: --Added following validation to copy the attachments
1598: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));
1599: FETCH cur_form_att INTO l_dummy;
1600: IF cur_form_att%FOUND THEN
1601: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1602: X_from_entity_name => 'FM_MATL_DTL',

Line 1602: X_from_entity_name => 'FM_MATL_DTL',

1598: OPEN cur_form_att('FM_MATL_DTL',to_char(X_dtl_tbl(i).formulaline_id));
1599: FETCH cur_form_att INTO l_dummy;
1600: IF cur_form_att%FOUND THEN
1601: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
1602: X_from_entity_name => 'FM_MATL_DTL',
1603: X_from_pk1_value => TO_CHAR(X_dtl_tbl(i).formulaline_id),
1604: X_from_pk2_value => NULL,
1605: X_from_pk3_value => NULL,
1606: X_from_pk4_value => NULL,

Line 1608: X_to_entity_name => 'FM_MATL_DTL',

1604: X_from_pk2_value => NULL,
1605: X_from_pk3_value => NULL,
1606: X_from_pk4_value => NULL,
1607: X_from_pk5_value => NULL,
1608: X_to_entity_name => 'FM_MATL_DTL',
1609: X_to_pk1_value => TO_CHAR(l_formulaline_id),
1610: X_to_pk2_value => NULL,
1611: X_to_pk3_value => NULL,
1612: X_to_pk4_value => NULL,